[Home] [Help]
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
303: AND mmt.organization_id = log.bound_level_entity_id
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
349: AND mmt.organization_id = log.bound_level_entity_id
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
394: AND mmt.organization_id = log.bound_level_entity_id
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
496: AND mmt.organization_id = log.bound_level_entity_id
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
538: AND mmt.organization_id = log.bound_level_entity_id
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
580: AND mmt.organization_id = log.bound_level_entity_id
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,
680: gtv.inventory_item_id,
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,
735: gtv.inventory_item_id,
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,
791: (
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
1056: AND p_lines.line_id = nvl(lines.top_model_line_id, lines.line_id)
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'
1136: AND lines.order_source_id <> 27 -- retroactive billing
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
1221: AND (p_mmt.transaction_type_id = 33 -- sales order issue, internal drop