POZ_SITE_ASSIGNMENTS_ALL_X
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: VIEW
Columns
Name |
---|
ASSIGNMENT_SPK_ID ASSIGNMENT_ID EFFECTIVE_END_DATE EFFECTIVE_START_DATE EFFECTIVE_SEQUENCE INACTIVE_DATE OBJECT_VERSION_NUMBER BU_ID VENDOR_SITE_ID AGENT_BU_ID BILL_TO_BU_ID ACCTS_PAY_CODE_COMBINATION_ID BILL_TO_LOCATION_ID DISTRIBUTION_SET_ID FUTURE_DATED_PAYMENT_CCID PREPAY_CODE_COMBINATION_ID SHIP_TO_LOCATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY |
Query
SQL_Statement |
---|
SELECT ASSIGNMENT_SPK_ID, ASSIGNMENT_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, EFFECTIVE_SEQUENCE, INACTIVE_DATE, OBJECT_VERSION_NUMBER, BU_ID, VENDOR_SITE_ID, AGENT_BU_ID, BILL_TO_BU_ID, ACCTS_PAY_CODE_COMBINATION_ID, BILL_TO_LOCATION_ID, DISTRIBUTION_SET_ID, FUTURE_DATED_PAYMENT_CCID, PREPAY_CODE_COMBINATION_ID, SHIP_TO_LOCATION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY FROM POZ_SITE_ASSIGNMENTS_ALL_M WHERE TRUNC(sysdate) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE AND EFFECTIVE_SEQUENCE = 9999 |