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_GLOBALS dependencies on MTL_SYSTEM_ITEMS

Line 1126: FROM mtl_system_items

1122: )
1123: IS
1124: Cursor Unit_Controlled_Item IS
1125: SELECT effectivity_control
1126: FROM mtl_system_items
1127: WHERE inventory_item_id = p_inventory_item_id
1128: AND organization_id = p_organization_id;
1129: BEGIN
1130: FOR Unit_Cont_Item IN Unit_Controlled_Item

Line 1181: FROM mtl_system_items

1177: )
1178: IS
1179: Cursor Unit_Controlled_Item IS
1180: SELECT effectivity_control
1181: FROM mtl_system_items
1182: WHERE inventory_item_id = p_inventory_item_id
1183: AND organization_id = p_organization_id;
1184: BEGIN
1185: FOR Unit_Cont_Item IN Unit_Controlled_Item

Line 1650: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1646:
1647: FUNCTION Get_Item_Name(p_item_id IN NUMBER,p_org_id IN NUMBER)
1648: RETURN VARCHAR2
1649: IS
1650: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1651: BEGIN
1652: SELECT concatenated_segments
1653: INTO l_item_name
1654: FROM mtl_system_items_kfv

Line 1654: FROM mtl_system_items_kfv

1650: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1651: BEGIN
1652: SELECT concatenated_segments
1653: INTO l_item_name
1654: FROM mtl_system_items_kfv
1655: WHERE inventory_item_id = p_item_id
1656: AND organization_id = p_org_id;
1657: RETURN l_item_name;
1658: EXCEPTION

Line 1886: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb

1882: -- Getting the change policy value.
1883: SELECT
1884: ecp.policy_char_value INTO l_change_policy_char_val
1885: FROM
1886: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
1887: WHERE
1888: ecp.policy_object_pk1_value =
1889: (SELECT TO_CHAR(ic.item_catalog_group_id)
1890: FROM mtl_item_catalog_groups_b ic

Line 1949: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP

1945:
1946: SELECT
1947: ecp.policy_char_value INTO l_change_policy_char_val
1948: FROM
1949: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP
1950: WHERE
1951: ecp.policy_object_pk1_value =
1952: (SELECT TO_CHAR(ic.item_catalog_group_id)
1953: FROM mtl_item_catalog_groups_b ic

Line 2180: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2176: (SELECT NVL(mirb.lifecycle_id, msi.lifecycle_id) AS lifecycle_id,
2177: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2178: msi.item_catalog_group_id item_catalog_group_id,
2179: msi.inventory_item_id, msi.organization_id , mirb.revision_id
2180: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2181: WHERE msi.INVENTORY_ITEM_ID = p_item_id
2182: AND msi.ORGANIZATION_ID = p_org_id
2183: AND mirb.revision_id = nvl(p_rev_id,BOM_Revisions.Get_Item_Revision_Id_Fn('ALL','ALL',p_org_id, p_item_id, p_rev_date) )
2184: AND (mirb.current_phase_id IS NOT NULL OR msi.current_phase_id IS NOT NULL)) ITEM_DTLS,

Line 2257: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2253: (SELECT NVL(mirb.lifecycle_id, msi.lifecycle_id) AS lifecycle_id,
2254: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2255: msi.item_catalog_group_id item_catalog_group_id,
2256: msi.inventory_item_id, msi.organization_id , mirb.revision
2257: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2258: WHERE msi.INVENTORY_ITEM_ID = p_item_id
2259: AND msi.ORGANIZATION_ID = p_org_id
2260: AND mirb.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID
2261: AND mirb.ORGANIZATION_ID = msi.ORGANIZATION_ID