APPS.OE_PREPAYMENT_UTIL dependencies on OE_ORDER_HEADERS

Line 336: FROM oe_order_headers oh

332: ,oh.source_document_id
333: ,oh.order_source_id
334: ,oh.change_sequence
335: ,oh.source_document_type_id
336: FROM oe_order_headers oh
337: ,oe_order_holds_all hd --moac
338: ,oe_hold_sources_all hs --moac
339: ,iby_trxn_extensions_v ite -- ccencryption
340: ,oe_payments op

Line 382: FROM oe_order_headers oh

378: ,oh.order_source_id
379: ,oh.change_sequence
380: ,oh.source_document_type_id
381: ,oh.org_id --bug4689411
382: FROM oe_order_headers oh
383: ,oe_order_holds_all hd --moac
384: ,oe_hold_sources_all hs --moac
385: ,oe_payments op
386: -- iby_trxn_extensions_v ite -- ccencryption

Line 430: FROM oe_order_headers oh

426: ,oh.order_source_id
427: ,oh.change_sequence
428: ,oh.source_document_type_id
429: ,oh.org_id --bug4689411
430: FROM oe_order_headers oh
431: ,oe_order_holds_all hd --moac
432: ,oe_hold_sources_all hs --moac
433: ,oe_payments op
434: WHERE oh.header_id= hd.header_id

Line 470: ,oe_order_headers oh

466: ,oh.change_sequence
467: ,oh.source_document_type_id
468: ,oh.org_id --bug4689411
469: FROM oe_order_lines_all ol --moac
470: ,oe_order_headers oh
471: ,oe_order_holds_all hd --moac
472: ,oe_hold_sources_all hs --moac
473: ,oe_payments op
474: -- ,iby_trxn_extensions_v ite -- ccencryption

Line 1105: FROM oe_order_headers

1101: ELSE
1102: BEGIN
1103: SELECT payment_type_code,payment_term_id
1104: INTO l_payment_type_code, l_payment_term_id
1105: FROM oe_order_headers
1106: WHERE header_id = p_header_id;
1107:
1108: EXCEPTION WHEN NO_DATA_FOUND THEN
1109: null;

Line 1365: from oe_order_headers_all

1361:
1362: Begin
1363: select payment_term_id, transactional_curr_code
1364: into l_term_id, l_curr_code
1365: from oe_order_headers_all
1366: where header_id = p_header_id;
1367: Exception
1368: when no_data_found then
1369: l_term_id := null;