[Home] [Help]
291: decode(p_lines.source_type_code, 'EXTERNAL', 2, 1 ),
292: decode(p_lines.order_source_id,10,1,0)
293: FROM opi_dbi_conc_prog_run_log log,
294: mtl_material_transactions mmt,
295: mtl_transaction_accounts mta,
296: oe_order_lines_all lines, -- child line
297: oe_order_lines_all p_lines, -- parent line
298: oe_order_headers_all header,
299: hz_cust_accounts cust_acct,
336: 1,
337: 0
338: FROM opi_dbi_conc_prog_run_log log,
339: mtl_material_transactions mmt,
340: mtl_transaction_accounts mta,
341: oe_order_lines_all lines, -- child line
342: oe_order_lines_all l_lines, -- linking line
343: oe_order_lines_all p_lines, -- parent line
344: oe_order_headers_all header,
382: 0
383: FROM opi_dbi_conc_prog_run_log log,
384: mtl_material_transactions mmt,
385: mtl_material_transactions p_mmt,
386: mtl_transaction_accounts mta,
387: oe_order_lines_all lines,
388: oe_order_lines_all p_lines, -- parent line
389: oe_order_headers_all header,
390: hz_cust_accounts cust_acct,
484: decode(p_lines.source_type_code, 'EXTERNAL', 2, 1 ),
485: decode(p_lines.order_source_id,10,1,0)
486: FROM opi_dbi_conc_prog_run_log log,
487: mtl_material_transactions mmt,
488: mtl_transaction_accounts mta,
489: oe_order_lines_all lines, -- child line
490: oe_order_lines_all p_lines, -- parent line
491: oe_order_headers_all header,
492: hz_cust_accounts cust_acct,
525: 1,
526: 0
527: FROM opi_dbi_conc_prog_run_log log,
528: mtl_material_transactions mmt,
529: mtl_transaction_accounts mta,
530: oe_order_lines_all lines, -- child line
531: oe_order_lines_all l_lines, -- linking line
532: oe_order_lines_all p_lines, -- parent line
533: oe_order_headers_all header,
568: 0
569: FROM opi_dbi_conc_prog_run_log log,
570: mtl_material_transactions mmt,
571: mtl_material_transactions p_mmt,
572: mtl_transaction_accounts mta,
573: oe_order_lines_all lines,
574: oe_order_lines_all p_lines, -- parent line
575: oe_order_headers_all header,
576: hz_cust_accounts cust_acct,