DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on PO_REQUISITION_LINES_ALL

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

Line 2939: po_requisition_lines_all prl,wsh_delivery_details wdd

2935: USING (SELECT ooh.header_id,ool.line_id,prl.requisition_line_id,prl.requisition_header_id,wdd.delivery_detail_id,
2936: ooh.org_id source_ou,prl.org_id destination_ou,prl.destination_organization_id dest_org,prl.source_organization_id source_org,
2937: prl.quantity,prl.item_id
2938: FROM oe_order_headers_all ooh, oe_order_lines_all ool,
2939: po_requisition_lines_all prl,wsh_delivery_details wdd
2940: WHERE ooh.source_document_id = l_requisition_id(i)
2941: AND ooh.header_id = ool.header_id
2942: AND ool.source_document_line_id = prl.requisition_line_id
2943: AND prl.requisition_header_id = l_requisition_id(i)