APPS.BOM_GLOBALS dependencies on BOM_REVISIONS

Line 1879: l_item_rev_code := BOM_REVISIONS.GET_ITEM_REVISION_FN('ALL', 'ALL', l_org_id, l_item_id, SYSDATE);

1875: /*IF p_item_revision_code IS NULL THEN
1876: SELECT Assembly_Item_id, Organization_Id into l_item_id, l_org_id
1877: FROM Bom_Structures_b
1878: WHERE Bill_Sequence_Id = p_bill_seq_id;
1879: l_item_rev_code := BOM_REVISIONS.GET_ITEM_REVISION_FN('ALL', 'ALL', l_org_id, l_item_id, SYSDATE);
1880: END IF;
1881: */
1882: -- Getting the change policy value.
1883: SELECT

Line 1943: --l_item_rev_code := BOM_REVISIONS.GET_ITEM_REVISION_FN('ALL', 'ALL', p_org_id, p_item_id, SYSDATE);

1939:
1940: BEGIN
1941: --get the current rev of the item, since structure header is independent of item rev.
1942: -- Commenting the revision related code, as structure change policies are not dependent on item's revision
1943: --l_item_rev_code := BOM_REVISIONS.GET_ITEM_REVISION_FN('ALL', 'ALL', p_org_id, p_item_id, SYSDATE);
1944: l_change_policy_char_val := 'ALLOWED';
1945:
1946: SELECT
1947: ecp.policy_char_value INTO l_change_policy_char_val

Line 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) )

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,
2185: ENG_CHANGE_POLICIES_V ECP
2186: WHERE
2187: ecp.policy_object_pk1_value =

Line 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) )

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
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

Line 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)) )

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
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 =