VIEW: APPS.CHV_RECEIVING_TRANSACTIONS_V

Source

View Text - Preformatted

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 , poh.org_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) , to_number(null) from chv_cum_adjustments cca

View Text - HTML Formatted

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
, POH.ORG_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)
, TO_NUMBER(NULL)
FROM CHV_CUM_ADJUSTMENTS CCA