APPS.OE_ORDER_GRP dependencies on OE_ORDER_LINES_ALL

Line 1626: FROM OE_ORDER_LINES_ALL

1622: source_document_line_id, orig_sys_shipment_ref
1623: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1624: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1625: l_source_document_line_id, l_orig_sys_shipment_ref
1626: FROM OE_ORDER_LINES_ALL
1627: WHERE line_id = x_Line_Adj_tbl(l_index).line_id;
1628: EXCEPTION
1629: WHEN NO_DATA_FOUND THEN
1630: l_order_source_id := null;

Line 1696: FROM OE_ORDER_LINES_ALL

1692: source_document_line_id, orig_sys_shipment_ref
1693: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1694: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1695: l_source_document_line_id, l_orig_sys_shipment_ref
1696: FROM OE_ORDER_LINES_ALL
1697: WHERE line_id = x_Line_Scredit_tbl(l_index).line_id;
1698: EXCEPTION
1699: WHEN NO_DATA_FOUND THEN
1700: l_order_source_id := null;

Line 1766: FROM OE_ORDER_LINES_ALL

1762: source_document_line_id, orig_sys_shipment_ref
1763: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1764: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1765: l_source_document_line_id, l_orig_sys_shipment_ref
1766: FROM OE_ORDER_LINES_ALL
1767: WHERE line_id = x_Line_Payment_tbl(l_index).line_id;
1768: EXCEPTION
1769: WHEN NO_DATA_FOUND THEN
1770: l_order_source_id := null;

Line 1836: FROM OE_ORDER_LINES_ALL

1832: source_document_line_id, orig_sys_shipment_ref
1833: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1834: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1835: l_source_document_line_id, l_orig_sys_shipment_ref
1836: FROM OE_ORDER_LINES_ALL
1837: WHERE line_id = x_Lot_Serial_tbl(l_index).line_id;
1838: EXCEPTION
1839: WHEN NO_DATA_FOUND THEN
1840: l_order_source_id := null;