APPS.OE_ORDER_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 337: from oe_order_headers_all

333: (g_header_id IS NULL)
334: THEN
335: select UPGRADED_FLAG, booked_flag into
336: g_upgraded_flag, g_booked_flag
337: from oe_order_headers_all
338: where header_id = p_header_id;
339: g_header_id := p_header_id;
340: END IF;
341:

Line 978: FROM OE_ORDER_HEADERS_ALL

974: SELECT order_source_id, orig_sys_document_ref, change_sequence,
975: source_document_type_id, source_document_id
976: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
977: l_source_document_type_id, l_source_document_id
978: FROM OE_ORDER_HEADERS_ALL
979: WHERE header_id = l_header_Scredit_rec.header_id;
980: EXCEPTION
981: WHEN NO_DATA_FOUND THEN
982: l_order_source_id := null;

Line 1021: FROM OE_ORDER_HEADERS_ALL

1017: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1018: source_document_type_id, source_document_id
1019: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1020: l_source_document_type_id, l_source_document_id
1021: FROM OE_ORDER_HEADERS_ALL
1022: WHERE header_id = l_old_header_Scredit_rec.header_id;
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: l_order_source_id := null;

Line 1561: FROM OE_ORDER_HEADERS_ALL

1557: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1558: source_document_type_id, source_document_id
1559: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1560: l_source_document_type_id, l_source_document_id
1561: FROM OE_ORDER_HEADERS_ALL
1562: WHERE header_id = l_header_Payment_rec.header_id;
1563: EXCEPTION
1564: WHEN NO_DATA_FOUND THEN
1565: l_order_source_id := null;

Line 1604: FROM OE_ORDER_HEADERS_ALL

1600: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1601: source_document_type_id, source_document_id
1602: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1603: l_source_document_type_id, l_source_document_id
1604: FROM OE_ORDER_HEADERS_ALL
1605: WHERE header_id = l_old_header_Payment_rec.header_id;
1606: EXCEPTION
1607: WHEN NO_DATA_FOUND THEN
1608: l_order_source_id := null;