Product: | CHV - Supplier Scheduling |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CHV_RECEIVING_TRANSACTIONS_V |
SELECT HRE.FULL_NAME
, RCT.TRANSACTION_DATE
, RCT.PRIMARY_UNIT_OF_MEASURE
, RCT.UNIT_OF_MEASURE
, RCT.SHIPMENT_HEADER_ID
, RSH.RECEIPT_NUM
, RSH.CREATION_DATE
, PLC.DISPLAYED_FIELD
, RCT.QUANTITY
, RCT.PRIMARY_QUANTITY
, TO_NUMBER(NULL)
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, RSL.ITEM_ID
, RCT.ORGANIZATION_ID
, RSL.SHIPMENT_LINE_ID
FROM HR_EMPLOYEES HRE
, RCV_TRANSACTIONS RCT
, PO_LOOKUP_CODES PLC
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_HEADERS POH
WHERE POH.PO_HEADER_ID = RCT.PO_HEADER_ID
AND RCT.EMPLOYEE_ID = HRE.EMPLOYEE_ID (+)
AND RSH.SHIPMENT_HEADER_ID = RCT.SHIPMENT_HEADER_ID
AND PLC.LOOKUP_TYPE = 'RCV TRANSACTION TYPE'
AND PLC.LOOKUP_CODE = RCT.TRANSACTION_TYPE
AND NVL(POH.SUPPLY_AGREEMENT_FLAG
, 'N') = 'Y'
AND RSL.SHIPMENT_LINE_ID = RCT.SHIPMENT_LINE_ID UNION SELECT NULL
, CCA.CREATION_DATE
, NULL
, CCA.PURCHASING_UNIT_OF_MEASURE
, CCA.CUM_TRANSACTION_ID
, NULL
, CCA.CREATION_DATE
, NULL
, CCA.ADJUSTMENT_QUANTITY
, TO_NUMBER(NULL)
, CCA.ADJUSTMENT_QUANTITY
, CCA.VENDOR_ID
, CCA.VENDOR_SITE_ID
, CCA.ITEM_ID
, CCA.ORGANIZATION_ID
, TO_NUMBER(NULL)
FROM CHV_CUM_ADJUSTMENTS CCA