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