DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 2938: FROM oe_order_headers_all ooh, oe_order_lines_all ool,

2934: MERGE INTO csd_product_transactions cpt
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

Line 3184: FROM oe_order_lines_all oel, oe_order_headers_all oeh,

3180: END IF;
3181:
3182: SELECT cpt.repair_line_id,oeh.header_id,ced.inventory_item_id,cr.incident_id
3183: INTO l_repair_line_id,l_header_id,l_ship_inv_item_id,l_incident_id
3184: FROM oe_order_lines_all oel, oe_order_headers_all oeh,
3185: cs_estimate_details ced, csd_product_transactions cpt,wsh_delivery_details wdd,
3186: csd_repairs cr
3187: WHERE oel.line_id = p_order_line_id
3188: AND oel.header_id = oeh.header_id