Procure to Pay Cycle’s Data Flow

-------Reqesation

select * from PO_REQUISITION_HEADERS_ALL where segment1 = '0001'
select * from PO_REQUISITION_LINES_ALL where requisition_header_id = 1
select * from PO_REQ_DISTRIBUTIONS_ALL where requisition_line_id = 1
------PO

SELECT pha.po_header_id, pha.type_lookup_code, pha.segment1, pha.summary_flag, pha.enabled_flag,
       pha.vendor_id, pha.vendor_site_id, pha.revision_num,pha.print_count,
       pha.confirming_order_flag,pha.acceptance_required_flag,pha.cancel_flag,
       pha.freight_terms_lookup_code,pha.frozen_flag, pha.document_creation_method,pha.style_id,
       pha.ship_to_location_id, pha.currency_code, pha.closed_code
FROM po_headers_all pha
WHERE segment1 = '0002'
SELECT pla.po_line_id, pla.category_id, pla.item_id, pla.po_header_id,
       pla.quantity, pla.closed_code,pla.unordered_flag,pla.closed_flag,
       pla.type_1099
FROM po_lines_all pla
WHERE po_header_id = 0003
SELECT pll.line_location_id, pll.ship_to_location_id, pll.po_header_id,
       pll.po_line_id, pll.quantity_received, pll.quantity_accepted,
       pll.quantity_rejected, pll.closed_code
FROM po_line_locations_all pll
WHERE po_header_id = 0003
  AND po_line_id    = 0004
 
select d.po_distribution_id,d.line_location_id,d.quantity_delivered,
       d.quantity_billed,d.quantity_cancelled,d.destination_type_code,
       d.destination_context
from po_distributions_all d
WHERE  d.po_header_id = 0003
AND    d.po_line_id    = 0004
select * from rcv_transactions_interface
where trunc(last_update_date) = trunc(sysdate)
SELECT *
FROM RCV_HEADERS_INTERFACE rhi
WHERE trunc(last_update_date) = trunc(sysdate)
and last_updated_by = 0005
ORDER BY rhi.last_update_date desc
select * from MTL_TRANSACTION_LOTS_INTERFACE
WHERE trunc(last_update_date) = trunc(sysdate)


SELECT *
FROM rcv_shipment_headers
WHERE shipment_header_id in  (SELECT shipment_header_id
                                FROM rcv_shipment_lines
                               WHERE po_header_id = 0003);
SELECT *
FROM rcv_shipment_lines
WHERE po_header_id = 0003;
SELECT *
FROM MTL_SUPPLY
WHERE po_header_id = 0003;
SELECT *
FROM RCV_SUPPLY
WHERE po_header_id = 0006
select * from rcv_lots_interface
where trunc(last_update_date) = trunc(sysdate)
ORDER BY last_update_date desc
select *
from mtl_transaction_lots_temp
ORDER BY last_update_date desc


-------Receiving

select * from rcv_transactions_interface
where trunc(last_update_date) = trunc(sysdate)


SELECT *
FROM RCV_HEADERS_INTERFACE rhi
WHERE trunc(last_update_date) = trunc(sysdate)
and last_updated_by = 0005
ORDER BY rhi.last_update_date desc
select * from MTL_TRANSACTION_LOTS_INTERFACE
WHERE trunc(last_update_date) = trunc(sysdate)


SELECT *
FROM rcv_shipment_headers
WHERE shipment_header_id in  (SELECT shipment_header_id
                                FROM rcv_shipment_lines
                               WHERE po_header_id = 0003);
SELECT *
FROM rcv_shipment_lines
WHERE po_header_id = 0003;
SELECT *
FROM MTL_SUPPLY
WHERE po_header_id = 0003;
SELECT *
FROM RCV_SUPPLY
WHERE po_header_id = 0006


SELECT *
FROM RCV_TRANSACTIONS_INTERFACE rti
WHERE po_header_id = 0003
  AND po_line_id    = 0004
ORDER BY rti.last_update_date des
SELECT *
FROM RCV_HEADERS_INTERFACE rhi
WHERE trunc(last_update_date) = trunc(sysdate)
and last_updated_by = 0005
ORDER BY rhi.last_update_date desc


SELECT *
 FROM MTL_TRANSACTION_LOT_NUMBERS
ORDER BY last_update_date desc
SELECT *
FROM MTL_TRANSACTION_LOT_NUMBERS
ORDER BY last_update_date desc
SELECT *
FROM MTL_LOT_NUMBERS
ORDER BY last_update_date desc
SELECT *
FROM MTL_ONHAND_QUANTITIES_DETAIL
WHERE trunc(last_update_date) = trunc(sysdate)
ORDER BY last_update_date desc


SELECT *
FROM MTL_ONHAND_DISCREPANCIES
ORDER BY last_update_date desc
                              
SELECT *
FROM RCV_TRANSACTIONS
WHERE po_header_id = 0003;
SELECT *
FROM wms_license_plate_numbers 
WHERE license_plate_number = 'LPN000'
SELECT *
FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
WHERE trunc(last_update_date) = trunc(sysdate)
ORDER BY last_update_date desc