APPS.OE_ORDER_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 1332: FROM OE_ORDER_HEADERS_ALL

1328: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1329: source_document_type_id, source_document_id
1330: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1331: l_source_document_type_id, l_source_document_id
1332: FROM OE_ORDER_HEADERS_ALL
1333: WHERE header_id = p_header_rec.header_Id;
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: l_order_source_id := null;

Line 1390: FROM OE_ORDER_HEADERS_ALL

1386: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1387: source_document_type_id, source_document_id
1388: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1389: l_source_document_type_id, l_source_document_id
1390: FROM OE_ORDER_HEADERS_ALL
1391: WHERE header_id = x_header_Adj_tbl(l_index).header_Id;
1392: EXCEPTION
1393: WHEN NO_DATA_FOUND THEN
1394: l_order_source_id := null;

Line 1452: FROM OE_ORDER_HEADERS_ALL

1448: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1449: source_document_type_id, source_document_id
1450: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1451: l_source_document_type_id, l_source_document_id
1452: FROM OE_ORDER_HEADERS_ALL
1453: WHERE header_id = x_header_Scredit_tbl(l_index).header_id;
1454: EXCEPTION
1455: WHEN NO_DATA_FOUND THEN
1456: l_order_source_id := null;

Line 1514: FROM OE_ORDER_HEADERS_ALL

1510: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1511: source_document_type_id, source_document_id
1512: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1513: l_source_document_type_id, l_source_document_id
1514: FROM OE_ORDER_HEADERS_ALL
1515: WHERE header_id = x_header_Payment_tbl(l_index).header_id;
1516: EXCEPTION
1517: WHEN NO_DATA_FOUND THEN
1518: l_order_source_id := null;