DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on OE_ORDER_LINES_ALL

Line 944: oe_order_lines_all ool,

940: ool.inventory_item_id,
941: pol.requisition_line_id,
942: wdd.delivery_detail_id
943: FROM oe_order_headers_all ooh,
944: oe_order_lines_all ool,
945: po_requisition_lines_all pol,
946: wsh_delivery_details wdd
947: WHERE ooh.orig_sys_document_ref = x_requisition_number
948: AND ooh.source_document_id = x_requisition_id

Line 1056: FROM oe_order_lines_all

1052: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Getting the split line id');
1053: END IF;
1054: SELECT line_id
1055: INTO l_order_rec.order_line_id
1056: FROM oe_order_lines_all
1057: WHERE split_from_line_id = p_order_line_id
1058: AND header_id = p_order_header_id;
1059: ELSE
1060: l_order_rec.order_line_id := p_order_line_id;