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 538: ) into bom_enabled,l_dummy from mtl_system_items

534: decode(eng_item_flag,
535: 'Y',decode(p_bom_header_rec.assembly_type,1,'E',null) --Eng item with manufacturing bill
536: --commented line below because MFG item is allowed on an ENG bill, bug 10429605
537: --'N',decode(p_bom_header_rec.assembly_type,2,'M',null) --Manufacturing item with Eng bill
538: ) into bom_enabled,l_dummy from mtl_system_items
539: where inventory_item_id = p_bom_head_unexp_rec.assembly_item_id
540: AND organization_id = p_bom_head_unexp_rec.organization_id;
541:
542: IF bom_enabled <> 'Y'

Line 911: FROM mtl_system_items assy,

907: --
908: BEGIN
909: SELECT '1'
910: INTO l_dummy
911: FROM mtl_system_items assy,
912: mtl_system_items common
913: WHERE assy.inventory_item_id =
914: p_bom_head_unexp_rec.assembly_item_id
915: AND assy.organization_id =

Line 912: mtl_system_items common

908: BEGIN
909: SELECT '1'
910: INTO l_dummy
911: FROM mtl_system_items assy,
912: mtl_system_items common
913: WHERE assy.inventory_item_id =
914: p_bom_head_unexp_rec.assembly_item_id
915: AND assy.organization_id =
916: p_bom_head_unexp_rec.organization_id

Line 1078: FROM mtl_system_items

1074: BEGIN
1075: SELECT bom_item_type, base_item_id, replenish_to_order_flag,
1076: pick_components_flag--, DECODE(eng_item_flag, 'Y', 2, 1)
1077: INTO bit, base_id, ato, pto--, assmtype
1078: FROM mtl_system_items
1079: WHERE inventory_item_id = p_bom_head_unexp_rec.assembly_item_id
1080: AND organization_id = p_bom_head_unexp_rec.organization_id;
1081:
1082:

Line 1096: FROM mtl_system_items s

1092: WHERE bic.bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id
1093: AND nvl(bic.disable_date, sysdate + 1) >= sysdate --- Bug: 3448641
1094: AND not exists
1095: (SELECT 'x'
1096: FROM mtl_system_items s
1097: WHERE s.organization_id = p_bom_head_unexp_rec.organization_id
1098: AND s.inventory_item_id = bic.component_item_id
1099: AND ((assmtype = 1 AND s.eng_item_flag = 'N')
1100: OR (assmtype = 2)

Line 1233: from mtl_system_items msi1, mtl_system_items msi2

1229: WHERE bic.bill_sequence_id =p_bom_head_unexp_rec.source_bill_sequence_id
1230: AND bic.component_sequence_id = bsc.component_sequence_id
1231: AND bsc.substitute_component_id not in
1232: (select msi1.inventory_item_id
1233: from mtl_system_items msi1, mtl_system_items msi2
1234: where msi1.organization_id = p_bom_head_unexp_rec.organization_id
1235: and msi1.inventory_item_id = bsc.substitute_component_id
1236: and msi1.bom_enabled_flag = 'Y'
1237: and msi2.organization_id = p_bom_head_unexp_rec.common_organization_id

Line 1344: FROM mtl_system_items

1340:
1341: SELECT bom_item_type, base_item_id, replenish_to_order_flag,
1342: pick_components_flag--, DECODE(eng_item_flag, 'Y', 2, 1)
1343: INTO bit, base_id, ato, pto--, assmtype
1344: FROM mtl_system_items
1345: WHERE inventory_item_id = p_bom_head_unexp_rec.assembly_item_id
1346: AND organization_id = p_bom_head_unexp_rec.organization_id;
1347:
1348: SELECT assembly_type

Line 1360: FROM mtl_system_items s

1356: WHERE bic.bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id
1357: AND nvl(bic.disable_date, sysdate + 1) >= sysdate
1358: AND not exists
1359: (SELECT 'x'
1360: FROM mtl_system_items s
1361: WHERE s.organization_id = p_bom_head_unexp_rec.organization_id
1362: AND s.inventory_item_id = bic.component_item_id
1363: AND ((assmtype = 1 AND s.eng_item_flag = 'N')
1364: OR (assmtype = 2)

Line 1433: from mtl_system_items msi1, mtl_system_items msi2

1429: WHERE bic.bill_sequence_id =p_bom_head_unexp_rec.source_bill_sequence_id
1430: AND bic.component_sequence_id = bsc.component_sequence_id
1431: AND bsc.substitute_component_id not in
1432: (select msi1.inventory_item_id
1433: from mtl_system_items msi1, mtl_system_items msi2
1434: where msi1.organization_id = p_bom_head_unexp_rec.organization_id
1435: and msi1.inventory_item_id = bsc.substitute_component_id
1436: and msi1.bom_enabled_flag = 'Y'
1437: and msi2.organization_id = p_bom_head_unexp_rec.common_organization_id

Line 1503: FROM mtl_system_items msi1, mtl_system_items msi2

1499: THEN
1500: BEGIN
1501: SELECT 1
1502: INTO l_count
1503: FROM mtl_system_items msi1, mtl_system_items msi2
1504: WHERE
1505: --Bug 2217522 msi1.organization_id = p_bom_head_unexp_rec.common_organization_id
1506: msi1.organization_id = p_bom_head_unexp_rec.organization_id --Bug 2217522
1507: AND msi1.inventory_item_id = p_bom_head_unexp_rec.assembly_item_id