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_SUPPLIER_PERFORM_FCV

Product:	PO - Purchasing
Description:	EDW Supplier Performance Fact Collection View
Implementation/DBA Data:	APPS.POABV_EDW_SUPPLIER_PERFORM_FCV

View Text

SELECT INC.SEQ_ID
, 1
, TO_CHAR(PLL.LINE_LOCATION_ID) || '-' || ELI.INSTANCE_CODE
, DECODE(POL.VENDOR_PRODUCT_NUM
, NULL
, 'NA_EDW'
, DECODE(PVS.VENDOR_SITE_CODE
, NULL
, 'NA_EDW'
, POV.VENDOR_NAME || '-' || PVS.VENDOR_SITE_CODE || '-' || POL.VENDOR_PRODUCT_NUM))
, EDW_LOOKUP_PKG.LOOKUP_CODE_FK('PO'
, 'PURCHASE CLASSIFICATION'
, POA_CUSTOMIZATION_PKG.PURCHASE_CLASSIFICATION_CODE( PLL.LINE_LOCATION_ID
, 'PO_LINE_LOCATIONS_ALL'))
, DECODE(POA_EDW_SUPPERF.GET_INVOICE_DATE(PLL.LINE_LOCATION_ID)
, NULL
, 'NA_EDW'
, TO_CHAR(POA_EDW_SUPPERF.GET_INVOICE_DATE(PLL.LINE_LOCATION_ID)
, 'DD-MM-YYYY') || '-'|| GSOB.PERIOD_SET_NAME || '-'|| GSOB.ACCOUNTED_PERIOD_TYPE || '-'|| ELI.INSTANCE_CODE || '-CD')
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, EDW_UTIL.GET_EDW_BASE_UOM(MUOM.UOM_CODE
, POL.ITEM_ID)
, 'NA_EDW')
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, EDW_UTIL.GET_EDW_UOM(MUOM.UOM_CODE
, POL.ITEM_ID)
, 'NA_EDW')
, ELI.INSTANCE_CODE
, EDW_TRD_PARTNER_PKG.SUPPLIER_SITE_FK (POH.VENDOR_SITE_ID
, POH.ORG_ID
, ELI.INSTANCE_CODE)
, EDW_ORGANIZATION_PKG.INT_ORGANIZATION_FK (PLL.SHIP_TO_ORGANIZATION_ID
, ELI.INSTANCE_CODE)
, DECODE(PLL.SHIP_TO_LOCATION_ID
, NULL
, 'NA_EDW'
, DECODE(HRL1.LOCATION_ID
, NULL
, EDW_GEOGRAPHY_PKG.HZ_POSTCODE_CITY_FK(PLL.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)
, EDW_ITEMS_PKG.ITEM_ORG_FK(POL.ITEM_ID
, DECODE(POL.ITEM_ID
, NULL
, PLL.ORG_ID
, FSP.INVENTORY_ORGANIZATION_ID)
, POL.ITEM_DESCRIPTION
, POL.CATEGORY_ID
, ELI.INSTANCE_CODE)
, EDW_HR_PERSON_PKG.REGULAR_EMPLOYEE_FK( NVL(POR.AGENT_ID
, POH.AGENT_ID)
, ELI.INSTANCE_CODE)
, DECODE(NVL(PLL.PROMISED_DATE
, NVL(PLL.NEED_BY_DATE
, PLL.CREATION_DATE))
, NULL
, 'NA_EDW'
, TO_CHAR(NVL(PLL.PROMISED_DATE
, NVL(PLL.NEED_BY_DATE
, PLL.CREATION_DATE))
, 'DD-MM-YYYY') || '-'|| GSOB.PERIOD_SET_NAME || '-'|| GSOB.ACCOUNTED_PERIOD_TYPE || '-'|| ELI.INSTANCE_CODE || '-CD')
, DECODE(PLL.PROMISED_DATE
, NULL
, 'NA_EDW'
, TO_CHAR(PLL.PROMISED_DATE
, 'DD-MM-YYYY') || '-'|| GSOB.PERIOD_SET_NAME || '-'|| GSOB.ACCOUNTED_PERIOD_TYPE || '-'|| ELI.INSTANCE_CODE || '-CD')
, DECODE(PLL.NEED_BY_DATE
, NULL
, 'NA_EDW'
, TO_CHAR(PLL.NEED_BY_DATE
, 'DD-MM-YYYY') || '-'|| GSOB.PERIOD_SET_NAME || '-'|| GSOB.ACCOUNTED_PERIOD_TYPE || '-'|| ELI.INSTANCE_CODE || '-CD')
, DECODE(PLL.CREATION_DATE
, NULL
, 'NA_EDW'
, TO_CHAR(PLL.CREATION_DATE
, 'DD-MM-YYYY') || '-'|| GSOB.PERIOD_SET_NAME || '-'|| GSOB.ACCOUNTED_PERIOD_TYPE || '-'|| ELI.INSTANCE_CODE || '-CD')
, DECODE(POA_EDW_SUPPERF.GET_FIRST_RECEIPT_DATE(PLL.LINE_LOCATION_ID)
, NULL
, 'NA_EDW'
, TO_CHAR(POA_EDW_SUPPERF.GET_FIRST_RECEIPT_DATE(PLL.LINE_LOCATION_ID)
, 'DD-MM-YYYY') || '-'|| GSOB.PERIOD_SET_NAME || '-'|| GSOB.ACCOUNTED_PERIOD_TYPE || '-'|| ELI.INSTANCE_CODE || '-CD')
, DECODE(PLL.LAST_ACCEPT_DATE
, NULL
, 'NA_EDW'
, TO_CHAR(PLL.LAST_ACCEPT_DATE
, 'DD-MM-YYYY') || '-'|| GSOB.PERIOD_SET_NAME || '-'|| GSOB.ACCOUNTED_PERIOD_TYPE || '-'|| ELI.INSTANCE_CODE || '-CD')
, DECODE(NVL(POA_OLTP_GENERIC_PKG.GET_APPROVED_DATE_PLL(PLL.CREATION_DATE
, PLL.LINE_LOCATION_ID)
, PLL.APPROVED_DATE)
, NULL
, 'NA_EDW'
, TO_CHAR(NVL(POA_OLTP_GENERIC_PKG.GET_APPROVED_DATE_PLL(PLL.CREATION_DATE
, PLL.LINE_LOCATION_ID)
, PLL.APPROVED_DATE)
, 'DD-MM-YYYY') || '-'|| GSOB.PERIOD_SET_NAME || '-'|| GSOB.ACCOUNTED_PERIOD_TYPE || '-'|| ELI.INSTANCE_CODE || '-CD')
, DECODE(POH.TERMS_ID
, NULL
, NULL
, POH.TERMS_ID || '-' || 'AP' || '-' || ELI.INSTANCE_CODE)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, DECODE(POL.PRICE_TYPE_LOOKUP_CODE
, NULL
, NULL
, UPPER(POL.PRICE_TYPE_LOOKUP_CODE) || '-' || 'PRICE TYPE' || '-' || 'PO')
, DECODE(PLL.CLOSED_CODE
, NULL
, NULL
, PLL.CLOSED_CODE || '-' || 'DOCUMENT STATE' || '-' || 'PO')
, PLT.LINE_TYPE
, POA_EDW_SUPPERF.GET_IPV(PLL.LINE_LOCATION_ID)
, POA_EDW_SUPPERF.GET_IPV(PLL.LINE_LOCATION_ID) * POA_EDW_VARIABLES_PKG.GET_GLOBAL_CURRENCY_RATE(POH.RATE_TYPE
, DECODE(POH.RATE_TYPE
, 'USER'
, GSOB.CURRENCY_CODE
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE))
, NVL(POH.RATE_DATE
, PLL.CREATION_DATE)
, POH.RATE)
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, PLL.PRICE_OVERRIDE / POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID))
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, PLL.PRICE_OVERRIDE / POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) * POA_EDW_VARIABLES_PKG.GET_GLOBAL_CURRENCY_RATE(POH.RATE_TYPE
, DECODE(POH.RATE_TYPE
, 'USER'
, GSOB.CURRENCY_CODE
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE))
, NVL(POH.RATE_DATE
, PLL.CREATION_DATE)
, POH.RATE))
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, POL.MARKET_PRICE / POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID))
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, POL.MARKET_PRICE / POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) * POA_EDW_VARIABLES_PKG.GET_GLOBAL_CURRENCY_RATE(POH.RATE_TYPE
, DECODE(POH.RATE_TYPE
, 'USER'
, GSOB.CURRENCY_CODE
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE))
, NVL(POH.RATE_DATE
, PLL.CREATION_DATE)
, POH.RATE))
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, POL.LIST_PRICE_PER_UNIT / POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID))
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, POL.LIST_PRICE_PER_UNIT / POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) * POA_EDW_VARIABLES_PKG.GET_GLOBAL_CURRENCY_RATE(POH.RATE_TYPE
, DECODE(POH.RATE_TYPE
, 'USER'
, GSOB.CURRENCY_CODE
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE))
, NVL(POH.RATE_DATE
, PLL.CREATION_DATE)
, POH.RATE))
, TO_NUMBER(NULL)
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, POA_CUSTOMIZATION_PKG.GET_TARGET_PRICE(PLL.LINE_LOCATION_ID) / POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) * POA_EDW_VARIABLES_PKG.GET_GLOBAL_CURRENCY_RATE(POH.RATE_TYPE
, DECODE(POH.RATE_TYPE
, 'USER'
, GSOB.CURRENCY_CODE
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE))
, NVL(POH.RATE_DATE
, PLL.CREATION_DATE)
, POH.RATE))
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, PLL.PRICE_OVERRIDE * (PLL.QUANTITY - PLL.QUANTITY_CANCELLED) * POA_EDW_VARIABLES_PKG.GET_GLOBAL_CURRENCY_RATE(POH.RATE_TYPE
, DECODE(POH.RATE_TYPE
, 'USER'
, GSOB.CURRENCY_CODE
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE))
, NVL(POH.RATE_DATE
, PLL.CREATION_DATE)
, POH.RATE))
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, PLL.PRICE_OVERRIDE * (PLL.QUANTITY - PLL.QUANTITY_CANCELLED))
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'AMOUNT'
, NULL
, PLL.QUANTITY * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID)))
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE PLL.QUANTITY_CANCELLED * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE POA_EDW_SUPPERF.GET_QTY_SHIPPED(PLL.LINE_LOCATION_ID
, POL.UNIT_MEAS_LOOKUP_CODE) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE POA_EDW_SUPPERF.GET_QTY_RECEIVED('ALL'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE POA_EDW_SUPPERF.GET_RCV_TXN_QTY(PLL.LINE_LOCATION_ID
, 'REJECT') * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE POA_EDW_SUPPERF.GET_RCV_TXN_QTY(PLL.LINE_LOCATION_ID
, 'ACCEPT') * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE POA_EDW_SUPPERF.GET_QTY_DELIVERED(PLL.LINE_LOCATION_ID) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE POA_EDW_SUPPERF.GET_NUM_RECEIPTS('ALL'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_NUM_RECEIPTS('EARLY'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_NUM_RECEIPTS('LATE'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_NUM_RECEIPTS('EARLYWINDOW'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_NUM_RECEIPTS('LATEWINDOW'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN POA_EDW_SUPPERF.GET_NUM_RECEIPTS('ONDATE'
, PLL.LINE_LOCATION_ID
, NULL
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) ELSE POA_EDW_SUPPERF.GET_NUM_RECEIPTS('ONDATE'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE POA_EDW_SUPPERF.GET_NUM_RECEIPTS('SUBSTITUTE'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_QTY_RECEIVED('EARLY'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_QTY_RECEIVED('LATE'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_QTY_PASTDUE(PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_QTY_RECEIVED('EARLYWINDOW'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN 0 ELSE POA_EDW_SUPPERF.GET_QTY_RECEIVED('LATEWINDOW'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL WHEN POH.SHIPPING_CONTROL='BUYER' THEN POA_EDW_SUPPERF.GET_QTY_RECEIVED('ONDATE'
, PLL.LINE_LOCATION_ID
, NULL
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) ELSE POA_EDW_SUPPERF.GET_QTY_RECEIVED('ONDATE'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POH.CONSIGNED_CONSUMPTION_FLAG = 'Y' OR POL.ORDER_TYPE_LOOKUP_CODE = 'AMOUNT' THEN NULL ELSE POA_EDW_SUPPERF.GET_QTY_RECEIVED('SUBSTITUTE'
, PLL.LINE_LOCATION_ID
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED) * POA_EDW_VARIABLES_PKG.GET_UOM_CONV_RATE(MUOM.UOM_CODE
, POL.ITEM_ID) END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG='Y' OR POH.CONSIGNED_CONSUMPTION_FLAG='Y' THEN NULL ELSE PLL.DAYS_EARLY_RECEIPT_ALLOWED END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG='Y' OR POH.CONSIGNED_CONSUMPTION_FLAG='Y' THEN NULL ELSE PLL.DAYS_LATE_RECEIPT_ALLOWED END
, CASE WHEN POR.CONSIGNED_CONSUMPTION_FLAG='Y' OR POH.CONSIGNED_CONSUMPTION_FLAG='Y' THEN NULL ELSE PLL.QTY_RCV_TOLERANCE END
, DECODE(PLL.CONSIGNED_FLAG
, 'Y'
, NULL
, POA_EDW_SUPPERF.GET_DAYS_TO_INVOICE( PLL.LINE_LOCATION_ID))
, PLL.RECEIVE_CLOSE_TOLERANCE
, GREATEST(GSOB.LAST_UPDATE_DATE
, PLT.LAST_UPDATE_DATE
, NVL(POV.LAST_UPDATE_DATE
, TO_DATE('02-01-1000'
, 'DD-MM-YYYY'))
, MUOM.LAST_UPDATE_DATE
, FSP.LAST_UPDATE_DATE
, PLL.LAST_UPDATE_DATE
, POL.LAST_UPDATE_DATE
, POH.LAST_UPDATE_DATE
, NVL(POA_EDW_SUPPERF.GET_LAST_RCV_TRX_DATE( PLL.LINE_LOCATION_ID)
, TO_DATE('02-01-1000'
, 'DD-MM-YYYY')))
, POH.SEGMENT1
, DECODE(GA.GLOBAL_AGREEMENT_FLAG
, 'Y'
, GA.SEGMENT1
, DECODE(PLL.SHIPMENT_TYPE
, 'STANDARD'
, POH2.SEGMENT1
, POH.SEGMENT1))
, POR.RELEASE_NUM
, NULL
, 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
, PLL.CREATION_DATE)
, NULL)
, -1
, 'RATE NOT AVAILABLE'
, -2
, 'INVALID CURRENCY'
, 'LOCAL READY') COLLECTION_STATUS
, '_DF:PO:PO_HEADERS:POH'
, '_DF:PO:PO_LINES:POL'
, '_DF:PO:PO_LINE_LOCATIONS:PLL'
FROM POA_EDW_SUP_PERF_INC INC
, EDW_LOCAL_INSTANCE ELI
, GL_SETS_OF_BOOKS GSOB
, PO_LINE_TYPES PLT
, PO_VENDORS POV
, MTL_UNITS_OF_MEASURE MUOM
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_RELEASES_ALL POR
, PO_LINES_ALL POL
, PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS_ALL PLL
, PO_VENDOR_SITES_ALL PVS
, HR_LOCATIONS_ALL HRL1
, PO_HEADERS_ALL GA
, PO_HEADERS_ALL POH2
WHERE INC.PRIMARY_KEY = PLL.LINE_LOCATION_ID
AND PLL.APPROVED_FLAG = 'Y'
AND PLL.SHIPMENT_TYPE IN ('BLANKET'
, 'SCHEDULED'
, 'STANDARD')
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID AND PLL.PO_LINE_ID = POL.PO_LINE_ID
AND POL.FROM_HEADER_ID = GA.PO_HEADER_ID (+) AND POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND POL.UNIT_MEAS_LOOKUP_CODE = MUOM.UNIT_OF_MEASURE AND POR.PO_RELEASE_ID (+)= PLL.PO_RELEASE_ID
AND NVL(FSP.ORG_ID
, -999) = NVL(PLL.ORG_ID
, -999)
AND GSOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND POV.VENDOR_ID (+)= POH.VENDOR_ID
AND PVS.VENDOR_ID (+)= POH.VENDOR_ID
AND PVS.VENDOR_SITE_ID (+)= POH.VENDOR_SITE_ID
AND PLL.SHIP_TO_LOCATION_ID = HRL1.LOCATION_ID (+)
AND POL.MATCHING_BASIS = 'QUANTITY'
AND POL.CONTRACT_ID =POH2.PO_HEADER_ID(+)

Columns

Name
SEQ_ID
VIEW_ID
SUP_PERF_PK
SUPPLIER_ITEM_FK
PURCH_CLASS_FK
INVOICE_DATE_FK
EDW_BASE_UOM_FK
EDW_UOM_FK
INSTANCE_FK
SUPPLIER_SITE_FK
SHIP_TO_ORG_FK
SHIP_LOCATION_FK
SUP_SITE_GEOG_FK
ITEM_FK
BUYER_FK
DATE_DIM_FK
PROMISED_DATE_FK
NEED_BY_DATE_FK
CREATION_DATE_FK
FIRST_REC_DATE_FK
LST_ACCPT_DATE_FK
APPROVAL_DATE_FK
AP_TERMS_FK
TXN_CUR_CODE_FK
PRICE_TYPE_FK
CLOSED_CODE_FK
PO_LINE_TYPE_FK
IPV_T
IPV_G
PRICE_T
PRICE_G
MARKET_PRICE_T
MARKET_PRICE_G
LIST_PRICE_T
LIST_PRICE_G
TARGET_PRICE_T
TARGET_PRICE_G
AMT_PURCHASED_G
AMT_PURCHASED_T
QTY_ORDERED_B
QTY_CANCELLED_B
QTY_SHIPPED_B
QTY_RECEIVED_B
QTY_REJECTED_B
QTY_ACCEPTED_B
QTY_DELIVERED_B
NUM_RECEIPT_LINES
NUM_EARLY_RECEIPT
NUM_LATE_RECEIPT
NUM_ONTIME_BEFDUE
NUM_ONTIME_AFTDUE
NUM_ONTIME_ONDUE
NUM_SUBS_RECEIPT
QTY_EARLY_RECEIPT_B
QTY_LATE_RECEIPT_B
QTY_PAST_DUE_B
QTY_ONTIME_BEFDUE_B
QTY_ONTIME_AFTDUE_B
QTY_ONTIME_ONDUE_B
QTY_SUBS_RECEIPT_B
DAYS_EARLY_REC
DAYS_LATE_REC
QTY_RECEIVED_TOL
NUM_DAYS_TO_INVOICE
RCV_CLOSE_TOL
LAST_UPDATE_DATE
PO_NUMBER
CONTRACT_NUM
RELEASE_NUM
OPERATION_CODE
DUNS_FK
UNSPSC_FK
SIC_CODE_FK
COLLECTION_STATUS
"_DF:PO_HDR:_EDW"
"_DF:PO_LINES:_EDW"
"_DF:PO_PLL:_EDW"