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.BOM_VALIDATE_BOM_HEADER dependencies on MTL_SYSTEM_ITEMS

Line 198: FROM mtl_system_items

194:
195: SELECT bom_item_type, decode(eng_item_flag, 'N', 1, 2)
196: ,tracking_quantity_ind
197: INTO l_bom_item_type, l_assembly_type,l_tracking_qty_ind
198: FROM mtl_system_items
199: WHERE inventory_item_id = p_assembly_item_id
200: AND organization_id = p_organization_id;
201:
202: SELECT process_enabled_flag

Line 527: select bom_enabled_flag into bom_enabled from mtl_system_items

523:
524: --
525: -- Verify that the Parent has BOM Enabled
526: --
527: select bom_enabled_flag into bom_enabled from mtl_system_items
528: where inventory_item_id = p_bom_head_unexp_rec.assembly_item_id
529: AND organization_id = p_bom_head_unexp_rec.organization_id;
530:
531: IF bom_enabled <> 'Y'

Line 870: FROM mtl_system_items assy,

866: --
867: BEGIN
868: SELECT '1'
869: INTO l_dummy
870: FROM mtl_system_items assy,
871: mtl_system_items common
872: WHERE assy.inventory_item_id =
873: p_bom_head_unexp_rec.assembly_item_id
874: AND assy.organization_id =

Line 871: mtl_system_items common

867: BEGIN
868: SELECT '1'
869: INTO l_dummy
870: FROM mtl_system_items assy,
871: mtl_system_items common
872: WHERE assy.inventory_item_id =
873: p_bom_head_unexp_rec.assembly_item_id
874: AND assy.organization_id =
875: p_bom_head_unexp_rec.organization_id

Line 1037: FROM mtl_system_items

1033: BEGIN
1034: SELECT bom_item_type, base_item_id, replenish_to_order_flag,
1035: pick_components_flag--, DECODE(eng_item_flag, 'Y', 2, 1)
1036: INTO bit, base_id, ato, pto--, assmtype
1037: FROM mtl_system_items
1038: WHERE inventory_item_id = p_bom_head_unexp_rec.assembly_item_id
1039: AND organization_id = p_bom_head_unexp_rec.organization_id;
1040:
1041: SELECT assembly_type

Line 1053: FROM mtl_system_items s

1049: WHERE bic.bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id
1050: AND nvl(bic.disable_date, sysdate + 1) >= sysdate --- Bug: 3448641
1051: AND not exists
1052: (SELECT 'x'
1053: FROM mtl_system_items s
1054: WHERE s.organization_id = p_bom_head_unexp_rec.organization_id
1055: AND s.inventory_item_id = bic.component_item_id
1056: AND ((assmtype = 1 AND s.eng_item_flag = 'N')
1057: OR (assmtype = 2)

Line 1168: from mtl_system_items msi1, mtl_system_items msi2

1164: WHERE bic.bill_sequence_id =p_bom_head_unexp_rec.source_bill_sequence_id
1165: AND bic.component_sequence_id = bsc.component_sequence_id
1166: AND bsc.substitute_component_id not in
1167: (select msi1.inventory_item_id
1168: from mtl_system_items msi1, mtl_system_items msi2
1169: where msi1.organization_id = p_bom_head_unexp_rec.organization_id
1170: and msi1.inventory_item_id = bsc.substitute_component_id
1171: and msi1.bom_enabled_flag = 'Y'
1172: and msi2.organization_id = p_bom_head_unexp_rec.common_organization_id

Line 1261: FROM mtl_system_items msi1, mtl_system_items msi2

1257: THEN
1258: BEGIN
1259: SELECT 1
1260: INTO l_count
1261: FROM mtl_system_items msi1, mtl_system_items msi2
1262: WHERE
1263: --Bug 2217522 msi1.organization_id = p_bom_head_unexp_rec.common_organization_id
1264: msi1.organization_id = p_bom_head_unexp_rec.organization_id --Bug 2217522
1265: AND msi1.inventory_item_id = p_bom_head_unexp_rec.assembly_item_id