DBA Data[Home] [Help]

APPS.OE_ORDER_GRP dependencies on OE_ORDER_LINES_ALL

Line 1715: FROM OE_ORDER_LINES_ALL

1711: source_document_line_id, orig_sys_shipment_ref
1712: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1713: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1714: l_source_document_line_id, l_orig_sys_shipment_ref
1715: FROM OE_ORDER_LINES_ALL
1716: WHERE line_id = x_Line_Adj_tbl(l_index).line_id;
1717: EXCEPTION
1718: WHEN NO_DATA_FOUND THEN
1719: l_order_source_id := null;

Line 1785: FROM OE_ORDER_LINES_ALL

1781: source_document_line_id, orig_sys_shipment_ref
1782: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1783: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1784: l_source_document_line_id, l_orig_sys_shipment_ref
1785: FROM OE_ORDER_LINES_ALL
1786: WHERE line_id = x_Line_Scredit_tbl(l_index).line_id;
1787: EXCEPTION
1788: WHEN NO_DATA_FOUND THEN
1789: l_order_source_id := null;

Line 1855: FROM OE_ORDER_LINES_ALL

1851: source_document_line_id, orig_sys_shipment_ref
1852: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1853: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1854: l_source_document_line_id, l_orig_sys_shipment_ref
1855: FROM OE_ORDER_LINES_ALL
1856: WHERE line_id = x_Line_Payment_tbl(l_index).line_id;
1857: EXCEPTION
1858: WHEN NO_DATA_FOUND THEN
1859: l_order_source_id := null;

Line 1925: FROM OE_ORDER_LINES_ALL

1921: source_document_line_id, orig_sys_shipment_ref
1922: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1923: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1924: l_source_document_line_id, l_orig_sys_shipment_ref
1925: FROM OE_ORDER_LINES_ALL
1926: WHERE line_id = x_Lot_Serial_tbl(l_index).line_id;
1927: EXCEPTION
1928: WHEN NO_DATA_FOUND THEN
1929: l_order_source_id := null;