POZ_SUPP_SITE_ASSIGN_REQUESTS

This staging table stores the information about supplier site assignment level attributes pertaining to change requests.

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

POZ_SUPP_SITE_ASSIGN_REQ_PK

SITE_ASSIGNMENT_REQUEST_ID

Columns

Name Datatype Length Precision Not-null Comments
SITE_ASSIGNMENT_REQUEST_ID NUMBER 18 Yes Value that uniquely identifies the assignment request.
SUPP_REQUEST_ID NUMBER 18 Yes This field is the unique identifier for a supplier request.
CHANGE_REQ_ROW_TYPE VARCHAR2 30 Yes Type of the request. This could either be 'CHANGE' or 'SNAPSHOT' or 'NEW'
SITE_ASSIGNMENT_ID NUMBER 18 Value that uniquely identifies the site assignment.
VENDOR_SITE_ID NUMBER 18 Value that uniquely identifies the supplier site.
SITE_REQUEST_ID NUMBER 18 This field is the unique identifier for a supplier site change request
BU_ID NUMBER 18 Value that uniquely identifies the business unit.
BILL_TO_BU_ID NUMBER 18 Bill-To Business Unit Identifier
ACCTS_PAY_CODE_COMBINATION_ID NUMBER 18 Yes Unique identifier for the supplier liability account
BILL_TO_LOCATION_ID NUMBER 18 Ship-to location unique identifier
DISTRIBUTION_SET_ID NUMBER 18 Value that uniquely identifies the distribution set.
FUTURE_DATED_PAYMENT_CCID NUMBER 18 Accounting flexfield identifier for the future dated payment account
PREPAY_CODE_COMBINATION_ID NUMBER 18 Unique identifier for the general ledger account for prepayment
SHIP_TO_LOCATION_ID NUMBER 18 Default ship-to location unique identifier
AWT_GROUP_ID NUMBER 18 Unique identifier for the withholding tax group
ALLOW_AWT_FLAG VARCHAR2 1 Indicator of whether Allow Withholding Tax is enabled
INACTIVE_DATE DATE Date when the site assignment becomes inactive.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table Foreign Table Foreign Key Column
POZ_SUPP_SITE_ASSIGN_REQUESTS poz_supp_requests SUPP_REQUEST_ID
POZ_SUPP_SITE_ASSIGN_REQUESTS gl_code_combinations ACCTS_PAY_CODE_COMBINATION_ID
POZ_SUPP_SITE_ASSIGN_REQUESTS gl_code_combinations FUTURE_DATED_PAYMENT_CCID
POZ_SUPP_SITE_ASSIGN_REQUESTS gl_code_combinations PREPAY_CODE_COMBINATION_ID
POZ_SUPP_SITE_ASSIGN_REQUESTS ap_distribution_sets_all DISTRIBUTION_SET_ID

Indexes

Index Uniqueness Tablespace Columns
POZ_SUPP_SITE_ASSIGN_REQ_N1 Non Unique Default SUPP_REQUEST_ID
POZ_SUPP_SITE_ASSIGN_REQ_N2 Non Unique POZ_SUPP_SITE_ASSIGN_REQ_N2 SITE_REQUEST_ID
POZ_SUPP_SITE_ASSIGN_REQ_U1 Unique Default SITE_ASSIGNMENT_REQUEST_ID