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

Line 916: FROM mtl_system_items

912: SELECT DECODE(restrict_subinventories_code, 1, 'Y', 'N'),
913: inventory_asset_flag
914: INTO l_RestrictSubInventory,
915: l_InventoryAsset
916: FROM mtl_system_items
917: WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
918: AND organization_id = g_rev_comp_Unexp_rec.organization_id;
919:
920: IF l_RestrictSubInventory = 'Y' THEN

Line 1052: FROM mtl_system_items

1048:
1049: -- Get Value of Item Locator
1050: SELECT location_control_code
1051: INTO l_item_locator_control
1052: FROM mtl_system_items
1053: WHERE organization_id = g_rev_comp_Unexp_rec.organization_id
1054: AND inventory_item_id = g_rev_comp_Unexp_rec.component_item_id;
1055:
1056: -- Get if locator is restricted or unrestricted

Line 1060: FROM mtl_system_items

1056: -- Get if locator is restricted or unrestricted
1057:
1058: SELECT RESTRICT_LOCATORS_CODE
1059: INTO l_item_loc_restricted
1060: FROM mtl_system_items
1061: WHERE organization_id = g_rev_comp_Unexp_rec.organization_id
1062: AND inventory_item_id = g_rev_comp_Unexp_rec.component_item_id;
1063:
1064: --

Line 1268: FROM mtl_system_items assy,

1264: FUNCTION Check_Optional RETURN BOOLEAN
1265: IS
1266: CURSOR c_CheckOptional IS
1267: SELECT 'Valid' is_Valid
1268: FROM mtl_system_items assy,
1269: mtl_system_items comp
1270: WHERE assy.organization_id = g_rev_comp_Unexp_rec.organization_id
1271: AND assy.inventory_item_id = g_rev_comp_Unexp_rec.revised_item_id
1272: AND comp.organization_id = g_rev_comp_Unexp_rec.organization_id

Line 1269: mtl_system_items comp

1265: IS
1266: CURSOR c_CheckOptional IS
1267: SELECT 'Valid' is_Valid
1268: FROM mtl_system_items assy,
1269: mtl_system_items comp
1270: WHERE assy.organization_id = g_rev_comp_Unexp_rec.organization_id
1271: AND assy.inventory_item_id = g_rev_comp_Unexp_rec.revised_item_id
1272: AND comp.organization_id = g_rev_comp_Unexp_rec.organization_id
1273: AND comp.inventory_item_id = g_rev_comp_Unexp_rec.component_item_id

Line 1326: FROM MTL_SYSTEM_ITEMS msi

1322: WHERE bom.common_bill_sequence_id =
1323: g_rev_comp_Unexp_rec.bill_sequence_id
1324: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
1325: AND NOT EXISTS (SELECT 1
1326: FROM MTL_SYSTEM_ITEMS msi
1327: WHERE msi.organization_id = bom.organization_id
1328: AND msi.inventory_item_id =
1329: g_rev_comp_Unexp_rec.component_item_id
1330: AND msi.bom_enabled_flag = 'Y'

Line 1340: FROM MTL_SYSTEM_ITEMS msi

1336: WHERE bom.common_bill_sequence_id =
1337: g_rev_comp_Unexp_rec.bill_sequence_id
1338: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
1339: AND NOT EXISTS (SELECT 1
1340: FROM MTL_SYSTEM_ITEMS msi
1341: WHERE msi.organization_id = bom.organization_id
1342: AND msi.inventory_item_id =
1343: g_rev_comp_Unexp_rec.component_item_id
1344: );

Line 1354: FROM MTL_SYSTEM_ITEMS msi

1350: WHERE bom.common_bill_sequence_id =
1351: g_rev_comp_Unexp_rec.bill_sequence_id
1352: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
1353: AND NOT EXISTS (SELECT 1
1354: FROM MTL_SYSTEM_ITEMS msi
1355: WHERE msi.organization_id = bom.organization_id
1356: AND msi.inventory_item_id =
1357: g_rev_comp_Unexp_rec.component_item_id
1358: AND msi.bom_enabled_flag = 'Y'

Line 1498: FROM mtl_system_items mi, eng_revised_items eri

1494: Is_Item_PTO VARCHAR2(1) := 'N';
1495:
1496: CURSOR c_ATO_PTO IS
1497: SELECT mi.replenish_to_order_flag, mi.pick_components_flag
1498: FROM mtl_system_items mi, eng_revised_items eri
1499: WHERE mi.inventory_item_id = eri.revised_item_id
1500: AND mi.organization_id = eri.organization_id
1501: AND eri.revised_item_sequence_id =
1502: p_rev_comp_Unexp_rec.revised_item_sequence_id;

Line 1506: FROM mtl_system_items

1502: p_rev_comp_Unexp_rec.revised_item_sequence_id;
1503:
1504: Cursor Unit_Controlled_Item IS
1505: SELECT effectivity_control
1506: FROM mtl_system_items
1507: WHERE inventory_item_id = p_rev_comp_unexp_rec.revised_item_id
1508: AND organization_id = p_rev_comp_unexp_rec.organization_id;
1509:
1510: l_bill_to_end_number VARCHAR2(30);

Line 1588: FROM mtl_system_items assy,

1584: g_Comp_ATP_Comp_flag,
1585: g_Comp_ATP_Check_flag,
1586: g_Comp_Bom_Enabled_flag,
1587: g_Comp_ATO_Forecast_Control
1588: FROM mtl_system_items assy,
1589: mtl_system_items comp
1590: WHERE assy.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
1591: AND assy.inventory_item_id = g_rev_Comp_Unexp_Rec.revised_item_id
1592: AND comp.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id

Line 1589: mtl_system_items comp

1585: g_Comp_ATP_Check_flag,
1586: g_Comp_Bom_Enabled_flag,
1587: g_Comp_ATO_Forecast_Control
1588: FROM mtl_system_items assy,
1589: mtl_system_items comp
1590: WHERE assy.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
1591: AND assy.inventory_item_id = g_rev_Comp_Unexp_Rec.revised_item_id
1592: AND comp.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
1593: AND comp.inventory_item_id = g_rev_Comp_Unexp_Rec.Component_item_id;

Line 3871: FROM mtl_system_items

3867: AND acd_type = 3;
3868:
3869: CURSOR c_Check_Unit_Effective IS
3870: SELECT effectivity_control
3871: FROM mtl_system_items
3872: WHERE inventory_item_id = p_component_item_id
3873: AND organization_id = p_organization_id;
3874:
3875: BEGIN

Line 3912: FROM mtl_system_items

3908: --
3909: ****************************************************************/
3910: SELECT bom_item_type
3911: INTO l_rev_comp_item_type
3912: FROM mtl_system_items
3913: WHERE inventory_item_id = p_component_item_id
3914: AND organization_id = p_organization_id;
3915:
3916: IF l_rev_comp_item_type NOT IN