RCV_PO_PJC_COMMITMENTS_V

Details

• Schema: FUSION

• Object owner: RCV

• Object type: VIEW

Columns

Name

RECEIPT_NUMBER RECEIPT_HEADER_ID RECEIPT_LINE_NUMBER RECEIPT_LINE_ID RECEIVING_ORGANIZATION_ID ITEM_ID ITEM_DESCRIPTION TRANSACTION_ID TRANSACTION_TYPE PARENT_TRANSACTION_ID PARENT_TRANSACTION_TYPE DELIVERED_QUANTITY DELIVER_UOM_CODE DELIVER_PRIMARY_QUANTITY DELIVER_PRIMARY_UOM_CODE DELIVER_SECONDARY_QUANTITY DELIVER_SECONDARY_UOM_CODE DELIVER_QTY_IN_ORDER_UOM ORDERED_UOM_CODE DELIVERED_AMOUNT PO_CURRENCY_CODE SOURCE_DOCUMENT_CODE PO_HEADER_ID PO_LINE_ID PO_LINE_LOCATION_ID PO_DISTRIBUTION_ID TRANSFER_ORDER_HEADER_ID TRANSFER_ORDER_LINE_ID TRANSFER_ORDER_DIST_ID RATE RATE_DATE DESTINATION_TYPE_CODE PJC_PROJECT_ID PJC_TASK_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_EXPENDITURE_TYPE_ID PJC_WORK_TYPE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_CONTEXT_CATEGORY PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_FUNDING_ALLOCATION_ID PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10

Query

SQL_Statement

SELECT rsh.receipt_num AS receipt_number , rsh.shipment_header_id AS receipt_header_id , rsl.line_num AS receipt_line_number , rsl.shipment_line_id AS receipt_line_id , rsl.to_organization_id AS receiving_organization_id , rsl.item_id AS item_id , rsl.item_description AS item_description , rt.transaction_id AS transaction_id , rt.transaction_type AS transaction_type , parent_rt.transaction_id AS parent_transaction_id , parent_rt.transaction_type AS parent_transaction_type , rt.quantity AS delivered_quantity , rt.uom_code AS deliver_uom_code , rt.primary_quantity AS deliver_primary_quantity , rt.primary_uom_code AS deliver_primary_uom_code , rt.secondary_quantity AS deliver_secondary_quantity , rt.secondary_uom_code AS deliver_secondary_uom_code , rt.source_doc_quantity AS deliver_qty_in_order_uom , rt.source_doc_uom_code AS ordered_uom_code , rt.amount AS delivered_amount , rt.currency_code AS po_currency_code , rt.source_document_code AS source_document_code , rt.po_header_id AS po_header_id , rt.po_line_id AS po_line_id , rt.po_line_location_id AS po_line_location_id , rt.po_distribution_id AS po_distribution_id , TO_NUMBER(NULL) AS transfer_order_header_id , TO_NUMBER(NULL) AS transfer_order_line_id , TO_NUMBER(NULL) AS transfer_order_dist_id , NVL(rt.currency_conversion_rate, pod.rate) AS rate , NVL(rt.currency_conversion_date, pod.rate_date) AS rate_date , POD.destination_type_code AS destination_type_code , pod.pjc_project_id , pod.pjc_task_id , DECODE(rcv_common.get_txndt_as_eidt_optin(), 'Y', RT.TRANSACTION_DATE, POD.PJC_EXPENDITURE_ITEM_DATE) AS pjc_expenditure_item_date , pod.pjc_organization_id , pod.pjc_expenditure_type_id , pod.pjc_work_type_id , pod.pjc_contract_id , pod.pjc_contract_line_id , pod.pjc_context_category , pod.pjc_billable_flag , pod.pjc_capitalizable_flag , pod.pjc_funding_allocation_id , pod.pjc_reserved_attribute1 , pod.pjc_reserved_attribute2 , pod.pjc_reserved_attribute3 , pod.pjc_reserved_attribute4 , pod.pjc_reserved_attribute5 , pod.pjc_reserved_attribute6 , pod.pjc_reserved_attribute7 , pod.pjc_reserved_attribute8 , pod.pjc_reserved_attribute9 , pod.pjc_reserved_attribute10 , pod.pjc_user_def_attribute1 , pod.pjc_user_def_attribute2 , pod.pjc_user_def_attribute3 , pod.pjc_user_def_attribute4 , pod.pjc_user_def_attribute5 , pod.pjc_user_def_attribute6 , pod.pjc_user_def_attribute7 , pod.pjc_user_def_attribute8 , pod.pjc_user_def_attribute9 , pod.pjc_user_def_attribute10 FROM rcv_transactions rt , rcv_transactions parent_rt , rcv_shipment_headers rsh , rcv_shipment_lines rsl , po_distributions_all pod WHERE rt.source_document_code = 'PO' AND ( (rt.transaction_type = 'DELIVER' ) OR (rt.transaction_type IN ('RETURN TO RECEIVING', 'CORRECT') and parent_rt.transaction_type = 'DELIVER') ) AND rt.accrual_status_code = 'PENDING' AND rt.parent_transaction_id = parent_rt.transaction_id AND rsh.shipment_header_id = rt.shipment_header_id AND rsl.shipment_line_id = rt.shipment_line_id AND rsl.shipment_header_id = rsh.shipment_header_id AND rt.po_distribution_id = pod.po_distribution_id