RCV_TO_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 , TO_NUMBER(NULL) AS parent_transaction_id , TO_CHAR(NULL) 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 , TO_NUMBER(NULL) AS po_header_id , TO_NUMBER(NULL) AS po_line_id , TO_NUMBER(NULL) AS po_line_location_id , TO_NUMBER(NULL) AS po_distribution_id , rt.transfer_order_header_id AS transfer_order_header_id , rt.transfer_order_line_id AS transfer_order_line_id , rt.transfer_order_dist_id AS transfer_order_dist_id , rt.currency_conversion_rate AS rate , rt.currency_conversion_date AS rate_date , rt.destination_type_code AS destination_type_code , itod.pjc_project_id , itod.pjc_task_id , rt.transaction_date AS pjc_expenditure_item_date , itod.pjc_organization_id , itod.pjc_expenditure_type_id , itod.pjc_work_type_id , itod.pjc_contract_id , itod.pjc_contract_line_id , itod.pjc_context_category , itod.pjc_billable_flag , itod.pjc_capitalizable_flag , itod.pjc_funding_allocation_id , itod.pjc_reserved_attribute1 , itod.pjc_reserved_attribute2 , itod.pjc_reserved_attribute3 , itod.pjc_reserved_attribute4 , itod.pjc_reserved_attribute5 , itod.pjc_reserved_attribute6 , itod.pjc_reserved_attribute7 , itod.pjc_reserved_attribute8 , itod.pjc_reserved_attribute9 , itod.pjc_reserved_attribute10 , itod.pjc_user_def_attribute1 , itod.pjc_user_def_attribute2 , itod.pjc_user_def_attribute3 , itod.pjc_user_def_attribute4 , itod.pjc_user_def_attribute5 , itod.pjc_user_def_attribute6 , itod.pjc_user_def_attribute7 , itod.pjc_user_def_attribute8 , itod.pjc_user_def_attribute9 , itod.pjc_user_def_attribute10 FROM rcv_transactions rt , rcv_shipment_headers rsh , rcv_shipment_lines rsl , inv_transfer_order_distribs itod WHERE rt.source_document_code = 'TRANSFER ORDER' AND rt.transaction_type IN ('DELIVER', 'RETURN TO ORGANIZATION') AND rt.accrual_status_code = 'PENDING' 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.transfer_order_dist_id = itod.distribution_id