[Home] [Help]
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,
300: mtl_system_items_b item
301: WHERE mmt.transaction_id >= log.from_bound_id
302: AND mmt.transaction_id < log.to_bound_id
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,
345: hz_cust_accounts cust_acct,
346: mtl_system_items_b item
347: WHERE mmt.transaction_id >= log.from_bound_id
348: AND mmt.transaction_id < log.to_bound_id
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,
391: mtl_system_items_b item
392: WHERE mmt.transaction_id >= log.from_bound_id
393: AND mmt.transaction_id < log.to_bound_id
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,
493: mtl_system_items_b item
494: WHERE mmt.transaction_id >= log.from_bound_id
495: AND mmt.transaction_id < log.to_bound_id
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,
534: hz_cust_accounts cust_acct,
535: mtl_system_items_b item
536: WHERE mmt.transaction_id >= log.from_bound_id
537: AND mmt.transaction_id < log.to_bound_id
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,
577: mtl_system_items_b item
578: WHERE mmt.transaction_id >= log.from_bound_id
579: AND mmt.transaction_id < log.to_bound_id
671: decode(p_lines.source_type_code, 'EXTERNAL', 2, 1 ),
672: decode(p_lines.order_source_id,10,1,0)
673: FROM oe_order_lines_all lines, -- child line
674: oe_order_lines_all p_lines, -- parent line
675: oe_order_headers_all header,
676: hz_cust_accounts cust_acct,
677: mtl_system_items_b item,
678: (
679: SELECT gtv.transaction_id,
726: 0
727: FROM oe_order_lines_all lines, -- child line
728: oe_order_lines_all l_lines, -- linking line
729: oe_order_lines_all p_lines, -- parent line
730: oe_order_headers_all header,
731: hz_cust_accounts cust_acct,
732: mtl_system_items_b item,
733: (
734: SELECT gtv.transaction_id,
782: 1,
783: 0
784: FROM oe_order_lines_all lines, -- child line
785: oe_order_lines_all p_lines, -- parent line
786: oe_order_headers_all header,
787: hz_cust_accounts cust_acct,
788: mtl_system_items_b item,
789: mtl_material_transactions mmt,
790: mtl_material_transactions p_mmt,
1047: gtv.line_id,
1048: gtv.transaction_date) gtv,
1049: oe_order_lines_all lines, -- child line
1050: oe_order_lines_all p_lines, -- parent line
1051: oe_order_headers_all header,
1052: hz_cust_accounts cust_acct,
1053: mtl_system_items_b item
1054: WHERE lines.line_id = gtv.line_id
1055: AND lines.order_source_id <> 27 -- retroactive billing
1127: gtv.transaction_date) gtv,
1128: oe_order_lines_all lines, -- child line
1129: oe_order_lines_all l_lines, -- linking line
1130: oe_order_lines_all p_lines, -- parent line
1131: oe_order_headers_all header,
1132: hz_cust_accounts cust_acct,
1133: mtl_system_items_b item
1134: WHERE lines.line_id = gtv.line_id
1135: AND lines.line_category_code = 'RETURN'
1212: mtl_material_transactions mmt,
1213: mtl_material_transactions p_mmt,
1214: oe_order_lines_all lines, -- child line
1215: oe_order_lines_all p_lines, -- parent line
1216: oe_order_headers_all header,
1217: hz_cust_accounts cust_acct,
1218: mtl_system_items_b item
1219: WHERE gtv.transaction_id = mmt.transaction_id
1220: AND p_mmt.transaction_id = mmt.parent_transaction_id