eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: POABV_EDW_AGREEMENT_LINES_FCV

Product:	PO - Purchasing
Description:	EDW Contract Agreement LIne Fact Collection View
Implementation/DBA Data:	APPS.POABV_EDW_AGREEMENT_LINES_FCV

View Text

SELECT INC.SEQ_ID
, 1
, TO_CHAR(POL.PO_LINE_ID) || '-' || ELI.INSTANCE_CODE
, ELI.INSTANCE_CODE
, EDW_HR_PERSON_PKG.REGULAR_EMPLOYEE_FK (POH.AGENT_ID
, ELI.INSTANCE_CODE)
, EDW_HR_PERSON_PKG.REGULAR_EMPLOYEE_FK (NVL(POA_EDW_SPEND_PKG.APPROVED_BY(POH.PO_HEADER_ID)
, POH.AGENT_ID)
, ELI.INSTANCE_CODE)
, EDW_ITEMS_PKG.ITEM_ORG_FK (POL.ITEM_ID
, DECODE(POL.ITEM_ID
, NULL
, POH.ORG_ID
, FSP.INVENTORY_ORGANIZATION_ID)
, POL.ITEM_DESCRIPTION
, POL.CATEGORY_ID
, ELI.INSTANCE_CODE)
, EDW_TRD_PARTNER_PKG.SUPPLIER_SITE_FK (POH.VENDOR_SITE_ID
, POH.ORG_ID
, ELI.INSTANCE_CODE)
, EDW_ORGANIZATION_PKG.OPERATING_UNIT_FK (POH.ORG_ID
, ELI.INSTANCE_CODE)
, EDW_TIME_PKG.CAL_DAY_FK( POH.CREATION_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)
, EDW_TIME_PKG.CAL_DAY_FK( POL.CREATION_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)
, DECODE(NVL(POA_OLTP_GENERIC_PKG.GET_APPROVED_DATE_POH(POL.CREATION_DATE
, POH.PO_HEADER_ID)
, POH.APPROVED_DATE)
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( NVL(POA_OLTP_GENERIC_PKG.GET_APPROVED_DATE_POH(POL.CREATION_DATE
, POH.PO_HEADER_ID)
, POH.APPROVED_DATE)
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE))
, DECODE(POH.REVISED_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( TO_DATE(POH.REVISED_DATE
, 'DD-MON-RR HH24:MI')
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE))
, DECODE(POH.START_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.START_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE))
, DECODE(POH.END_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.END_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE))
, DECODE(POH.ACCEPTANCE_DUE_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.ACCEPTANCE_DUE_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE))
, DECODE(POH.RATE_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.RATE_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE))
, DECODE(POH.PRINTED_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.PRINTED_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE))
, DECODE(POH.TERMS_ID
, NULL
, NULL
, (POH.TERMS_ID || '-' || 'AP' || '-' || ELI.INSTANCE_CODE))
, DECODE(POH.CLOSED_CODE
, NULL
, NULL
, (UPPER(POH.CLOSED_CODE) || '-' || 'DOCUMENT STATE' || '-' || 'PO'))
, DECODE(POH.TYPE_LOOKUP_CODE
, NULL
, NULL
, (UPPER(POH.TYPE_LOOKUP_CODE) || '-' || 'AGREEMENT TYPE' || '-' || 'POD'))
, DECODE(POH.SHIP_VIA_LOOKUP_CODE
, NULL
, NULL
, (UPPER(POH.SHIP_VIA_LOOKUP_CODE) || '-' || 'SHIP VIA TYPE' || '-' || 'ORG'))
, DECODE(POH.FOB_LOOKUP_CODE
, NULL
, NULL
, (UPPER(POH.FOB_LOOKUP_CODE) || '-' || 'FOB' || '-' || 'PO'))
, DECODE(POH.FREIGHT_TERMS_LOOKUP_CODE
, NULL
, NULL
, (UPPER(POH.FREIGHT_TERMS_LOOKUP_CODE) || '-' || 'FREIGHT TERMS' || '-' || 'PO'))
, DECODE(POL.TRANSACTION_REASON_CODE
, NULL
, NULL
, (UPPER(POL.TRANSACTION_REASON_CODE) || '-' || 'TRANSACTION REASON' || '-' || 'PO'))
, DECODE(POL.PRICE_TYPE_LOOKUP_CODE
, NULL
, NULL
, (UPPER(POL.PRICE_TYPE_LOOKUP_CODE) || '-' || 'PRICE TYPE' || '-' || 'PO'))
, DECODE(POL.PRICE_BREAK_LOOKUP_CODE
, NULL
, NULL
, (UPPER(POL.PRICE_BREAK_LOOKUP_CODE) || '-' || 'PRICE BREAK TYPE' || '-' || 'PO'))
, NVL(POH.ACCEPTANCE_REQUIRED_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POH.FROZEN_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POH.APPROVED_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POH.USER_HOLD_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POH.CONFIRMING_ORDER_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POH.SUPPLY_AGREEMENT_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POL.NEGOTIATED_BY_PREPARER_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POL.CANCEL_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POL.CLOSED_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, NVL(POH.EDI_PROCESSED_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND'
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, EDW_UTIL.GET_EDW_BASE_UOM(MTLU.UOM_CODE
, POL.ITEM_ID)
, 'NA_EDW')
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, EDW_UTIL.GET_EDW_UOM(MTLU.UOM_CODE
, POL.ITEM_ID)
, 'NA_EDW')
, DECODE(POH.BILL_TO_LOCATION_ID
, NULL
, 'NA_EDW'
, HRL2.TOWN_OR_CITY || '-' || HRL2.POSTAL_CODE || '-' || HRL2.REGION_2 || '-' || HRL2.COUNTRY)
, DECODE(POH.SHIP_TO_LOCATION_ID
, NULL
, 'NA_EDW'
, DECODE(HRL1.LOCATION_ID
, NULL
, EDW_GEOGRAPHY_PKG.HZ_POSTCODE_CITY_FK(POH.SHIP_TO_LOCATION_ID)
, HRL1.TOWN_OR_CITY || '-' || HRL1.POSTAL_CODE || '-' || HRL1.REGION_2 || '-' || HRL1.COUNTRY))
, DECODE(POH.VENDOR_SITE_ID
, NULL
, 'NA_EDW'
, PVS.CITY || '-' || PVS.ZIP || '-' || DECODE(PVS.STATE
, NULL
, PVS.PROVINCE
, PVS.STATE) || '-' || PVS.COUNTRY)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, POH.RATE_TYPE
, PLT.LINE_TYPE
, DECODE(POH.START_DATE
, LEAST(POH.START_DATE
, SYSDATE)
, DECODE(POH.END_DATE
, GREATEST(POH.END_DATE
, SYSDATE)
, 'Y'
, DECODE(POH.END_DATE
, NULL
, 'Y'
, 'N'))
, DECODE(POH.START_DATE
, NULL
, DECODE(POH.END_DATE
, GREATEST(POH.END_DATE
, SYSDATE)
, 'Y'
, DECODE(POH.END_DATE
, NULL
, 'Y'
, 'N'))
, 'N')) || '-' || 'YES_NO' || '-' || 'FND'
, EDW_SUPPLIER_ITEM_PKG.SUPPLIER_ITEM_FK ( POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, POL.VENDOR_PRODUCT_NUM)
, POL.COMMITTED_AMOUNT
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POL.COMMITTED_AMOUNT
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POL.COMMITTED_AMOUNT
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, POH.RATE_TYPE))
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.QUANTITY * EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, NULL)
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.MIN_ORDER_QUANTITY * EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, NULL)
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.MAX_ORDER_QUANTITY * EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, NULL)
, POL.MARKET_PRICE / EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POL.MARKET_PRICE
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POL.MARKET_PRICE
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, POH.RATE_TYPE)) / EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, POL.NOT_TO_EXCEED_PRICE / EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POL.NOT_TO_EXCEED_PRICE
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POL.NOT_TO_EXCEED_PRICE
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, POH.RATE_TYPE)) / EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, POL.LIST_PRICE_PER_UNIT / EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POL.LIST_PRICE_PER_UNIT
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POL.LIST_PRICE_PER_UNIT
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, POH.RATE_TYPE)) / EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, POL.UNIT_PRICE / EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POL.UNIT_PRICE
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POL.UNIT_PRICE
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, POH.RATE_TYPE)) / EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, POL.MIN_RELEASE_AMOUNT
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POL.MIN_RELEASE_AMOUNT
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POL.MIN_RELEASE_AMOUNT
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, POH.RATE_TYPE))
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.QUANTITY_COMMITTED * EDW_UTIL.GET_UOM_CONV_RATE ( MTLU.UOM_CODE
, POL.ITEM_ID)
, NULL)
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POA_EDW_SPEND_PKG.LINE_QTY_RELEASED( POL.PO_HEADER_ID
, POL.ORG_ID
, POL.PO_LINE_ID) * EDW_UTIL.GET_UOM_CONV_RATE (MTLU.UOM_CODE
, POL.ITEM_ID)
, NULL)
, POA_EDW_SPEND_PKG.LINE_AMT_RELEASED( POL.PO_HEADER_ID
, POL.ORG_ID
, POL.PO_LINE_ID)
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POA_EDW_SPEND_PKG.LINE_AMT_RELEASED (POL.PO_HEADER_ID
, POL.ORG_ID
, POL.PO_LINE_ID)
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POA_EDW_SPEND_PKG.LINE_AMT_RELEASED (POL.PO_HEADER_ID
, POL.ORG_ID
, POL.PO_LINE_ID)
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, POH.RATE_TYPE))
, NVL(POA_OLTP_GENERIC_PKG.GET_APPROVED_DATE_POH(POL.CREATION_DATE
, POH.PO_HEADER_ID)
, POH.APPROVED_DATE) - POL.CREATION_DATE
, NVL(POH.PRINTED_DATE
, POH.APPROVED_DATE) - POH.APPROVED_DATE
, POH.ACCEPTANCE_DUE_DATE - NVL(POH.PRINTED_DATE
, POH.APPROVED_DATE)
, POL.ITEM_ID
, POL.ITEM_DESCRIPTION
, NVL(POL.NOTE_TO_VENDOR
, POH.NOTE_TO_VENDOR)
, POH.COMMENTS
, POH.NOTE_TO_RECEIVER
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POL.CANCEL_REASON
, GREATEST(POH.LAST_UPDATE_DATE
, POL.LAST_UPDATE_DATE
, NVL(POV.LAST_UPDATE_DATE
, TO_DATE('01/01/0001'
, 'MM/DD/YYYY'))
, FSP.LAST_UPDATE_DATE
, PLT.LAST_UPDATE_DATE
, GSOB.LAST_UPDATE_DATE
, MTLU.LAST_UPDATE_DATE)
, NULL
, NULL
, NULL
, DECODE(EDW_CURRENCY.GET_RATE( DECODE(POH.RATE_TYPE
, 'USER'
, GSOB.CURRENCY_CODE
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE))
, NVL(POH.RATE_DATE
, POL.CREATION_DATE)
, NULL)
, -1
, 'RATE NOT AVAILABLE'
, -2
, 'INVALID CURRENCY'
, 'LOCAL READY') COLLECTION_STATUS
, '_DF:PO:PO_HEADERS:POH'
, '_DF:PO:PO_LINES:POL'
FROM POA_EDW_ALINES_INC INC
, PO_LINES_ALL POL
, PO_HEADERS_ALL POH
, PO_VENDORS POV
, MTL_UNITS_OF_MEASURE MTLU
, GL_SETS_OF_BOOKS GSOB
, PO_LINE_TYPES PLT
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, EDW_LOCAL_INSTANCE ELI
, PO_VENDOR_SITES_ALL PVS
, HR_LOCATIONS_ALL HRL1
, HR_LOCATIONS_ALL HRL2
WHERE INC.PRIMARY_KEY = POL.PO_LINE_ID
AND POL.PO_HEADER_ID = POH.PO_HEADER_ID AND POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID AND POL.UNIT_MEAS_LOOKUP_CODE = MTLU.UNIT_OF_MEASURE(+) AND POH.VENDOR_ID = POV.VENDOR_ID (+)
AND NVL(POH.ORG_ID
, -999) = NVL(FSP.ORG_ID
, -999) AND FSP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND PVS.VENDOR_ID (+)= POH.VENDOR_ID
AND PVS.VENDOR_SITE_ID (+)= POH.VENDOR_SITE_ID
AND POH.SHIP_TO_LOCATION_ID = HRL1.LOCATION_ID (+)
AND POH.BILL_TO_LOCATION_ID = HRL2.LOCATION_ID (+)

Columns

Name
SEQ_ID
VIEW_ID
AGREE_LN_INST_PK
INSTANCE_FK
BUYER_FK
APPROVER_FK
ITEM_REVISION_FK
SUPPLIER_SITE_FK
OPERATING_UNIT_FK
PO_CREATE_DATE_FK
LNE_CREAT_DATE_FK
APPROVED_DATE_FK
REVISED_DATE_FK
START_DATE_FK
END_DATE_FK
ACCPT_DUE_DATE_FK
TXN_CUR_DATE_FK
PO_PRINT_DATE_FK
AP_TERMS_FK
PO_CLOSED_FK
PO_TYPE_FK
SHIP_VIA_FK
FOB_FK
FREIGHT_TERMS_FK
TXN_REASON_FK
PRICE_TYPE_FK
PRICE_BREAK_FK
ACCPT_REQUIRED_FK
FROZEN_FK
APPROVED_FK
USER_HOLD_FK
CONFIRM_ORDER_FK
SUPPLY_AGREE_FK
NEG_BY_PREPARE_FK
CANCELLED_FK
LNE_CLOSED_FK
EDI_PROCESSED_FK
BASE_UOM_FK
TXN_UOM_FK
BILL_LOCATION_FK
SHIP_LOCATION_FK
SUP_SITE_GEOG_FK
TXN_CUR_CODE_FK
TXN_CUR_RATE_TYPE
PO_LINE_TYPE_FK
CONTRACT_EFFECTIVE_FK
SUPPLIER_ITEM_NUM_FK
AMT_AGREED_T
AMT_AGREED_G
QTY_ORDERED_T
QTY_MIN_ORDER_T
QTY_MAX_ORDER_T
MARKET_PRICE_T
MARKET_PRICE_G
PRICE_LIMIT_T
PRICE_LIMIT_G
LIST_PRICE_T
LIST_PRICE_G
UNIT_PRICE_T
UNIT_PRICE_G
AMT_MIN_RELEASE_T
AMT_MIN_RELEASE_G
QTY_AGREED_T
QTY_RELEASED_T
AMT_RELEASED_T
AMT_RELEASED_G
NUM_DAYS_CREATE_TO_APP
NUM_DAYS_APP_TO_SEND
NUM_DAYS_APP_SEND_TO_ACCPT
ITEM_ID
ITEM_DESCRIPTION
PO_SUPPLIER_NOTE
COMMENTS
RECEIVER_NOTE
PO_HEADER_ID
PO_LINE_ID
CANCEL_REASON
LAST_UPDATE_DATE
DUNS_FK
UNSPSC_FK
SIC_CODE_FK
COLLECTION_STATUS
"_DF:PO_HDR:_EDW"
"_DF:PO_LINES:_EDW"