APPS.BOM_GLOBALS dependencies on ENG_CHANGE_POLICIES_V

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 2185: ENG_CHANGE_POLICIES_V ECP

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,
2185: ENG_CHANGE_POLICIES_V ECP
2186: WHERE
2187: ecp.policy_object_pk1_value =
2188: (SELECT TO_CHAR(ic.item_catalog_group_id)
2189: FROM mtl_item_catalog_groups_b ic

Line 2265: ENG_CHANGE_POLICIES_V ECP

2261: AND mirb.ORGANIZATION_ID = msi.ORGANIZATION_ID
2262: AND mirb.revision >= nvl(p_start_rev,BOM_Revisions.Get_Item_Revision_Fn('ALL','ALL',p_org_id, p_item_id, p_effective_date) )
2263: AND mirb.revision <= nvl(p_end_rev,decode(p_disable_date,null,mirb.revision,BOM_Revisions.Get_Item_Revision_Fn('ALL','ALL',p_org_id, p_item_id, p_disable_date)) )
2264: AND (mirb.current_phase_id IS NOT NULL OR msi.current_phase_id IS NOT NULL)) ITEM_DTLS,
2265: ENG_CHANGE_POLICIES_V ECP
2266: WHERE
2267: ecp.policy_object_pk1_value =
2268: (SELECT TO_CHAR(ic.item_catalog_group_id)
2269: FROM mtl_item_catalog_groups_b ic