eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_COGS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 300: mtl_system_items_b item

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
304: AND log.load_type = 'INIT'

Line 346: mtl_system_items_b item

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
350: AND log.load_type = 'INIT'

Line 391: mtl_system_items_b item

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
395: AND log.load_type = 'INIT'

Line 493: mtl_system_items_b item

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
497: AND log.load_type = 'INCR'

Line 535: mtl_system_items_b item

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
539: AND log.load_type = 'INCR'

Line 577: mtl_system_items_b item

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
581: AND log.load_type = 'INCR'

Line 677: mtl_system_items_b item,

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,
681: gtv.organization_id,

Line 732: mtl_system_items_b item,

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,
736: gtv.organization_id,

Line 788: mtl_system_items_b item,

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: (
792: SELECT gtv.transaction_id,

Line 1053: mtl_system_items_b item

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)
1057: AND lines.header_id = header.header_id

Line 1133: mtl_system_items_b item

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
1137: AND l_lines.line_id = nvl(lines.link_to_line_id, lines.line_id)

Line 1218: mtl_system_items_b item

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
1222: OR p_mmt.transaction_type_id = 19) -- logical PO receipt, external drop