Table: PO_APPROVED_SUPPLIER_LIST
| Description: | Approved supplier list |
|---|
Primary Key: PO_APPROVED_SUPPLIER_LIST_PK
- ASL_ID
Foreign Keys from this table:
| Foreign Key Column | Foreign Table |
|---|---|
| PO_APPROVED_SUPPLIER_LIST.VENDOR_SITE_ID | PO_VENDOR_SITES_ALL |
| PO_APPROVED_SUPPLIER_LIST.VENDOR_ID | PO_VENDORS |
Comments
PO_APPROVED_SUPPLIER_LIST stores the relationship between an item or
commodity; a supplier, distributor, or manufacturer; ship-to
organizations; and approval/certification status.
Indexes
| Index | Type | Tablespace | Column |
|---|---|---|---|
| PO_APPROVED_SUPPLIER_LIST_U1 | UNIQUE | APPS_TS_TX_IDX | ASL_ID |
| PO_APPROVED_SUPPLIER_LIST_N1 | NONUNIQUE | APPS_TS_TX_IDX | ITEM_ID VENDOR_ID |
| PO_APPROVED_SUPPLIER_LIST_N2 | NONUNIQUE | APPS_TS_TX_IDX | CATEGORY_ID VENDOR_ID |
| PO_APPROVED_SUPPLIER_LIST_N3 | NONUNIQUE | APPS_TS_TX_IDX | VENDOR_ID PRIMARY_VENDOR_ITEM |
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ASL_ID | NUMBER | Y | ASL unique identifier | |
| USING_ORGANIZATION_ID | NUMBER | Y | Ship-to organization using this record | |
| OWNING_ORGANIZATION_ID | NUMBER | Y | Organization that created the record initially | |
| VENDOR_BUSINESS_TYPE | VARCHAR2 | (25) | Y | Business type of Distributor, Direct, or Manufacturer |
| ASL_STATUS_ID | NUMBER | Y | Approval/certification status | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| MANUFACTURER_ID | NUMBER | Manufacturer | ||
| VENDOR_ID | NUMBER | Supplier | ||
| ITEM_ID | NUMBER | Item | ||
| CATEGORY_ID | NUMBER | Category | ||
| VENDOR_SITE_ID | NUMBER | Supplier site | ||
| PRIMARY_VENDOR_ITEM | VARCHAR2 | (25) | Supplier, Manufacturer, or Distributor item number | |
| MANUFACTURER_ASL_ID | NUMBER | Manufacturer associated with distributor | ||
| REVIEW_BY_DATE | DATE | Review by date | ||
| COMMENTS | VARCHAR2 | (240) | Comments | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| DISABLE_FLAG | VARCHAR2 | (1) | Indicator of whether the ASL entry has been disabled |
PO.PO_APPROVED_SUPPLIER_LIST does not reference any database object
PO.PO_APPROVED_SUPPLIER_LIST is referenced by following:
- PO
- VIEW - PO_APPROVED_SUPPLIER_LIST#
Table: PO_APPROVED_SUPPLIER_LIST_GT
| Description: |
|---|
Comments
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SESSION_KEY | NUMBER | |||
| USER_KEY | NUMBER | |||
| PROCESS_ACTION | VARCHAR2 | (30) | ||
| PROCESS_STATUS | VARCHAR2 | (30) | ||
| ASL_ID | NUMBER | |||
| USING_ORGANIZATION_ID | NUMBER | |||
| USING_ORGANIZATION_DSP | VARCHAR2 | (240) | ||
| OWNING_ORGANIZATION_ID | NUMBER | |||
| OWNING_ORGANIZATION_DSP | VARCHAR2 | (240) | ||
| VENDOR_BUSINESS_TYPE | VARCHAR2 | (25) | ||
| ASL_STATUS_ID | NUMBER | |||
| ASL_STATUS_DSP | VARCHAR2 | (25) | ||
| MANUFACTURER_ID | NUMBER | |||
| MANUFACTURER_DSP | VARCHAR2 | (100) | ||
| VENDOR_ID | NUMBER | |||
| VENDOR_DSP | VARCHAR2 | (240) | ||
| ITEM_ID | NUMBER | |||
| ITEM_DSP | VARCHAR2 | (50) | ||
| CATEGORY_ID | NUMBER | |||
| CATEGORY_DSP | VARCHAR2 | (240) | ||
| VENDOR_SITE_ID | NUMBER | |||
| VENDOR_SITE_DSP | VARCHAR2 | (240) | ||
| PRIMARY_VENDOR_ITEM | VARCHAR2 | (25) | ||
| MANUFACTURER_ASL_ID | NUMBER | |||
| MANUFACTURER_ASL_DSP | VARCHAR2 | (50) | ||
| REVIEW_BY_DATE | DATE | |||
| COMMENTS | VARCHAR2 | (240) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| DISABLE_FLAG | VARCHAR2 | (1) |
PO.PO_APPROVED_SUPPLIER_LIST_GT does not reference any database object
PO.PO_APPROVED_SUPPLIER_LIST_GT is referenced by following:
- APPS
- SYNONYM - PO_APPROVED_SUPPLIER_LIST_GT
Table: PO_ASL_API_ERRORS
| Description: |
|---|
Comments
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| USER_KEY | NUMBER | |||
| SESSION_KEY | NUMBER | |||
| ENTITY_NAME | VARCHAR2 | (50) | ||
| REJECTION_REASON | VARCHAR2 | (2000) |
PO.PO_ASL_API_ERRORS does not reference any database object
PO.PO_ASL_API_ERRORS is referenced by following:
- PO
- VIEW - PO_ASL_API_ERRORS#
Table: PO_ASL_ATTRIBUTES
| Description: | Approved supplier list attributes |
|---|
Comments
PO_ASL_ATTRIBUTES stores all information for the
supplier/item/organization relationship defined in
PO_APPROVED_SUPPLIER_LIST. This information
is maintained separately to allow each organization to define its own
attributes, even if using a Global ASL entry for the supplier/item
relationship and approval status.
Indexes
| Index | Type | Tablespace | Column |
|---|---|---|---|
| PO_ASL_ATTRIBUTES_U1 | UNIQUE | APPS_TS_TX_IDX | ASL_ID USING_ORGANIZATION_ID |
| PO_ASL_ATTRIBUTES_N1 | NONUNIQUE | APPS_TS_TX_IDX | VENDOR_ID ITEM_ID |
| PO_ASL_ATTRIBUTES_N2 | NONUNIQUE | APPS_TS_TX_IDX | USING_ORGANIZATION_ID |
| PO_ASL_ATTRIBUTES_N3 | NONUNIQUE | APPS_TS_TX_IDX | ENABLE_VMI_FLAG |
| PO_ASL_ATTRIBUTES_N4 | NONUNIQUE | APPS_TS_TX_IDX | CONSIGNED_FROM_SUPPLIER_FLAG |
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ASL_ID | NUMBER | Y | ASL unique identifier | |
| USING_ORGANIZATION_ID | NUMBER | Y | Ship-to organization using record | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| DOCUMENT_SOURCING_METHOD | VARCHAR2 | (25) | No longer used | |
| RELEASE_GENERATION_METHOD | VARCHAR2 | (25) | Automatic release method | |
| PURCHASING_UNIT_OF_MEASURE | VARCHAR2 | (25) | Supplier unit of measure | |
| ENABLE_PLAN_SCHEDULE_FLAG | VARCHAR2 | (1) | Enable planning schedules | |
| ENABLE_SHIP_SCHEDULE_FLAG | VARCHAR2 | (1) | Enable shipping schedules | |
| PLAN_SCHEDULE_TYPE | VARCHAR2 | (25) | Default planning schedule type | |
| SHIP_SCHEDULE_TYPE | VARCHAR2 | (25) | Default shipping schedule type | |
| PLAN_BUCKET_PATTERN_ID | NUMBER | Default planning schedule bucket pattern | ||
| SHIP_BUCKET_PATTERN_ID | NUMBER | Default shipping schedule bucket pattern | ||
| ENABLE_AUTOSCHEDULE_FLAG | VARCHAR2 | (1) | Autoschedule enabled | |
| SCHEDULER_ID | NUMBER | Scheduler | ||
| ENABLE_AUTHORIZATIONS_FLAG | VARCHAR2 | (1) | Authorizations enabled | |
| VENDOR_ID | NUMBER | Supplier | ||
| VENDOR_SITE_ID | NUMBER | Supplier site | ||
| ITEM_ID | NUMBER | Item | ||
| CATEGORY_ID | NUMBER | Category | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| PRICE_UPDATE_TOLERANCE | NUMBER | Maximum percentage increase allowed to price/sales catalog update sent by supplier (832 EDI transaction) | ||
| PROCESSING_LEAD_TIME | NUMBER | Processing lead time in number of days | ||
| MIN_ORDER_QTY | NUMBER | Minimum quantity that needs to be ordered | ||
| FIXED_LOT_MULTIPLE | NUMBER | Minimum lot multiple that can be ordered on top of minimum-order quantity | ||
| DELIVERY_CALENDAR | VARCHAR2 | (10) | Name of the delivery calendar | |
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Code for the item's country of manufacture | |
| ENABLE_VMI_FLAG | VARCHAR2 | (1) | VMI enabled indicator | |
| VMI_MIN_QTY | NUMBER | Min Quantity for VMI replenishment | ||
| VMI_MAX_QTY | NUMBER | Max Quantity for VMI replenishment | ||
| ENABLE_VMI_AUTO_REPLENISH_FLAG | VARCHAR2 | (1) | Used by Collaborative Planning to allow/disallow automatic replenishment function | |
| VMI_REPLENISHMENT_APPROVAL | VARCHAR2 | (30) | Indicates the party with ability to release replenishment requests automatically using Collaborative Planning. Valid values: None, Supplier or Buyer, Buyer | |
| CONSIGNED_FROM_SUPPLIER_FLAG | VARCHAR2 | (1) | Indicates that a consigned from supplierrelationship has been established in the ASL. | |
| LAST_BILLING_DATE | DATE | Date of the last consumption advice created. | ||
| CONSIGNED_BILLING_CYCLE | NUMBER | Indicate the interval (in days) that must elapse between the creation of consumption advice. Used in conjunction with LAST_BILLING_DATE by the "Create Consumption Advice" concurrent program. | ||
| CONSUME_ON_AGING_FLAG | VARCHAR2 | (1) | Indicates whether aging-based consumption is applicable. | |
| AGING_PERIOD | NUMBER | Number of days that can elapse before a consigned receipt becomes due for consumption. | ||
| REPLENISHMENT_METHOD | NUMBER | The type of inventory replenishment method used by Collaborative Planning to calculate replenishment points. | ||
| VMI_MIN_DAYS | NUMBER | Minimum days of inventory supply that needs to be held in the inventory organization. | ||
| VMI_MAX_DAYS | NUMBER | Maximum days of inventory supply that needs to be held in the inventory organization. | ||
| FIXED_ORDER_QUANTITY | NUMBER | Order quantity that Collaborative Planning will create a requisition for if the replenishment method selected includes a fixed order quantity. | ||
| FORECAST_HORIZON | NUMBER | Number of working days in the order forecast considered by Collaborative Planning to calculate the average daily usage. |
PO.PO_ASL_ATTRIBUTES does not reference any database object
PO.PO_ASL_ATTRIBUTES is referenced by following:
- PO
- VIEW - PO_ASL_ATTRIBUTES#
Table: PO_ASL_ATTRIBUTES_GT
| Description: |
|---|
Comments
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SESSION_KEY | NUMBER | |||
| USER_KEY | NUMBER | |||
| PROCESS_ACTION | VARCHAR2 | (30) | ||
| ASL_ID | NUMBER | |||
| USING_ORGANIZATION_ID | NUMBER | |||
| USING_ORGANIZATION_DSP | VARCHAR2 | (50) | ||
| DOCUMENT_SOURCING_METHOD | VARCHAR2 | (25) | ||
| RELEASE_GENERATION_METHOD | VARCHAR2 | (25) | ||
| RELEASE_GENERATION_METHOD_DSP | VARCHAR2 | (50) | ||
| PURCHASING_UNIT_OF_MEASURE_DSP | VARCHAR2 | (25) | ||
| ENABLE_PLAN_SCHEDULE_FLAG_DSP | VARCHAR2 | (1) | ||
| ENABLE_SHIP_SCHEDULE_FLAG_DSP | VARCHAR2 | (1) | ||
| PLAN_SCHEDULE_TYPE | VARCHAR2 | (25) | ||
| PLAN_SCHEDULE_TYPE_DSP | VARCHAR2 | (50) | ||
| SHIP_SCHEDULE_TYPE | VARCHAR2 | (25) | ||
| SHIP_SCHEDULE_TYPE_DSP | VARCHAR2 | (50) | ||
| PLAN_BUCKET_PATTERN_ID | NUMBER | |||
| PLAN_BUCKET_PATTERN_DSP | VARCHAR2 | (50) | ||
| SHIP_BUCKET_PATTERN_ID | NUMBER | |||
| SHIP_BUCKET_PATTERN_DSP | VARCHAR2 | (50) | ||
| ENABLE_AUTOSCHEDULE_FLAG_DSP | VARCHAR2 | (1) | ||
| SCHEDULER_ID | NUMBER | |||
| SCHEDULER_DSP | VARCHAR2 | (50) | ||
| ENABLE_AUTHORIZATIONS_FLAG_DSP | VARCHAR2 | (1) | ||
| VENDOR_ID | NUMBER | |||
| VENDOR_DSP | VARCHAR2 | (50) | ||
| VENDOR_SITE_ID | NUMBER | |||
| VENDOR_SITE_DSP | VARCHAR2 | (50) | ||
| ITEM_ID | NUMBER | |||
| ITEM_DSP | VARCHAR2 | (50) | ||
| CATEGORY_ID | NUMBER | |||
| CATEGORY_DSP | VARCHAR2 | (50) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| PRICE_UPDATE_TOLERANCE_DSP | NUMBER | |||
| PROCESSING_LEAD_TIME_DSP | NUMBER | |||
| MIN_ORDER_QTY_DSP | NUMBER | |||
| FIXED_LOT_MULTIPLE_DSP | NUMBER | |||
| DELIVERY_CALENDAR_DSP | VARCHAR2 | (10) | ||
| COUNTRY_OF_ORIGIN_CODE_DSP | VARCHAR2 | (2) | ||
| ENABLE_VMI_FLAG_DSP | VARCHAR2 | (1) | ||
| VMI_MIN_QTY_DSP | NUMBER | |||
| VMI_MAX_QTY_DSP | NUMBER | |||
| ENABLE_VMI_AUTO_REPLENISH_FLAG | VARCHAR2 | (1) | ||
| VMI_REPLENISHMENT_APPROVAL | VARCHAR2 | (30) | ||
| VMI_REPLENISHMENT_APPROVAL_DSP | VARCHAR2 | (30) | ||
| CONSIGNED_FROM_SUPP_FLAG_DSP | VARCHAR2 | (1) | ||
| LAST_BILLING_DATE | DATE | |||
| CONSIGNED_BILLING_CYCLE_DSP | NUMBER | |||
| CONSUME_ON_AGING_FLAG_DSP | VARCHAR2 | (1) | ||
| AGING_PERIOD_DSP | NUMBER | |||
| REPLENISHMENT_METHOD | NUMBER | |||
| REPLENISHMENT_METHOD_DSP | VARCHAR2 | (50) | ||
| VMI_MIN_DAYS_DSP | NUMBER | |||
| VMI_MAX_DAYS_DSP | NUMBER | |||
| FIXED_ORDER_QUANTITY_DSP | NUMBER | |||
| FORECAST_HORIZON_DSP | NUMBER |
PO.PO_ASL_ATTRIBUTES_GT does not reference any database object
PO.PO_ASL_ATTRIBUTES_GT is referenced by following:
- APPS
- SYNONYM - PO_ASL_ATTRIBUTES_GT
Table: PO_ASL_DOCUMENTS
| Description: | Approved supplier list documents |
|---|
Comments
PO_ASL_DOCUMENTS stores sourcing references to supply agreements,
blanket agreements, and catalog quotations associated with particular
suppliers and items in PO_APPROVED_SUPPLIER_LIST.
Indexes
| Index | Type | Tablespace | Column |
|---|---|---|---|
| PO_ASL_DOCUMENTS_U1 | UNIQUE | APPS_TS_TX_IDX | ASL_ID USING_ORGANIZATION_ID DOCUMENT_HEADER_ID |
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ASL_ID | NUMBER | Y | ASL unique identifier | |
| USING_ORGANIZATION_ID | NUMBER | Y | Ship-to organization using record | |
| SEQUENCE_NUM | NUMBER | Y | Document ranking | |
| DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | Y | Document type |
| DOCUMENT_HEADER_ID | NUMBER | Y | Document header unique identifier | |
| DOCUMENT_LINE_ID | NUMBER | Document line unique identifier | ||
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| ORG_ID | NUMBER | Organization identifier |
PO.PO_ASL_DOCUMENTS does not reference any database object
PO.PO_ASL_DOCUMENTS is referenced by following:
- PO
- VIEW - PO_ASL_DOCUMENTS#
Table: PO_ASL_DOCUMENTS_GT
| Description: |
|---|
Comments
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SESSION_KEY | NUMBER | |||
| USER_KEY | NUMBER | |||
| PROCESS_ACTION | VARCHAR2 | (30) | ||
| ASL_ID | NUMBER | |||
| USING_ORGANIZATION_ID | NUMBER | |||
| USING_ORGANIZATION_DSP | VARCHAR2 | (50) | ||
| SEQUENCE_NUM | NUMBER | |||
| DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | ||
| DOCUMENT_TYPE_DSP | VARCHAR2 | (50) | ||
| DOCUMENT_HEADER_ID | NUMBER | |||
| DOCUMENT_HEADER_DSP | VARCHAR2 | (25) | ||
| DOCUMENT_LINE_ID | NUMBER | |||
| DOCUMENT_LINE_NUM_DSP | NUMBER | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| ORG_ID | NUMBER |
PO.PO_ASL_DOCUMENTS_GT does not reference any database object
PO.PO_ASL_DOCUMENTS_GT is referenced by following:
- APPS
- SYNONYM - PO_ASL_DOCUMENTS_GT
Table: PO_ASL_STATUSES
| Description: | Approved supplier list statuses |
|---|
Primary Key: PO_ASL_STATUSES_PK
- STATUS_ID
Comments
PO_ASL_STATUSES stores the user-defined approval/certification
statuses.
Indexes
| Index | Type | Tablespace | Column |
|---|---|---|---|
| PO_ASL_STATUSES_U1 | UNIQUE | APPS_TS_SEED | STATUS_ID ZD_EDITION_NAME |
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STATUS_ID | NUMBER | Y | Status unique identifier | |
| STATUS | VARCHAR2 | (25) | Y | Status name |
| STATUS_DESCRIPTION | VARCHAR2 | (240) | Y | Status description |
| ASL_DEFAULT_FLAG | VARCHAR2 | (1) | Y | Default status for new approved supplier list records |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| INACTIVE_DATE | DATE | Inactive date | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
PO.PO_ASL_STATUSES does not reference any database object
PO.PO_ASL_STATUSES is referenced by following:
- PO
- VIEW - PO_ASL_STATUSES#
Table: PO_ASL_STATUS_RULES
| Description: | Approved supplier list status rules |
|---|
Primary Key: PO_ASL_STATUS_RULES_PK
- BUSINESS_RULE
- STATUS_ID
Comments
PO_ASL_STATUS_RULES stores the business rules associated with each
status.
Indexes
| Index | Type | Tablespace | Column |
|---|---|---|---|
| PO_ASL_STATUS_RULES_U1 | NONUNIQUE | APPS_TS_SEED | STATUS_ID |
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STATUS_ID | NUMBER | Y | Status unique identifier | |
| BUSINESS_RULE | VARCHAR2 | (25) | Y | Business rule |
| ALLOW_ACTION_FLAG | VARCHAR2 | (1) | Y | Indicator of whether action is allowed |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). |
PO.PO_ASL_STATUS_RULES does not reference any database object