DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on PO_REQUISITION_HEADERS_ALL

Line 2879: FROM po_requisition_headers_all

2875:
2876: BEGIN
2877: SELECT requisition_header_id,authorization_status,type_lookup_code
2878: BULK COLLECT INTO l_requisition_id,l_authorization,l_req_type
2879: FROM po_requisition_headers_all
2880: WHERE request_id = l_request_id
2881: AND creation_date > SYSDATE - 1;
2882:
2883: FOR i IN 1 ..l_requisition_id.COUNT

Line 2897: FROM po_requisition_headers_all prh,po_requisition_lines_all prl,

2893: ELSE
2894: -- SELECT all the requisition id's originated from CSD and are not yet interfaced to OM.
2895: SELECT prh.requisition_header_id
2896: BULK COLLECT INTO l_requisition_id
2897: FROM po_requisition_headers_all prh,po_requisition_lines_all prl,
2898: csd_repair_job_xref crj,csd_wip_transaction_details cwt
2899: WHERE crj.wip_entity_id = cwt.wip_entity_id
2900: AND cwt.wip_entity_id = prl.wip_entity_id
2901: AND cwt.inventory_item_id = prl.item_id