DBA Data[Home] [Help]

APPS.OE_PREPAYMENT_UTIL dependencies on OE_HOLD_SOURCES_ALL

Line 338: ,oe_hold_sources_all hs --moac

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
341: WHERE oh.header_id= hd.header_id
342: AND hd.hold_source_id = hs.hold_source_id

Line 384: ,oe_hold_sources_all hs --moac

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
387: ,IBY_FNDCPT_TX_EXTENSIONS x
388: ,IBY_PMT_INSTR_USES_ALL u

Line 432: ,oe_hold_sources_all hs --moac

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
435: AND hd.hold_source_id = hs.hold_source_id
436: AND hs.hold_id in (l_hold1, l_hold2, l_hold3)

Line 472: ,oe_hold_sources_all hs --moac

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
475: ,IBY_FNDCPT_TX_EXTENSIONS x
476: ,IBY_PMT_INSTR_USES_ALL u