1. Tables and Views for Procurement
  2. POZ_SITE_ASSIGNMENTS_ALL_X

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