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
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
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)
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