APPS.BOM_EXPLODER_PUB dependencies on MTL_PARAMETERS

Line 976: FROM MTL_PARAMETERS

972: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID)
973: AND (BIC.TO_END_ITEM_REV_ID IS NULL
974: OR (NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),
975: (SELECT STARTING_REVISION
976: FROM MTL_PARAMETERS
977: WHERE ORGANIZATION_ID = BET.ORGANIZATION_ID)) <= (SELECT REVISION
978: FROM MTL_ITEM_REVISIONS_B
979: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
980: AND ORGANIZATION_ID = BET.ORGANIZATION_ID

Line 1004: FROM MTL_PARAMETERS

1000: AND ORGANIZATION_ID = BET.ORGANIZATION_ID
1001: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID)
1002: AND ((NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),
1003: (SELECT STARTING_REVISION
1004: FROM MTL_PARAMETERS
1005: WHERE ORGANIZATION_ID = BET.ORGANIZATION_ID)) > = (SELECT REVISION
1006: FROM MTL_ITEM_REVISIONS_B
1007: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
1008: AND ORGANIZATION_ID = BET.ORGANIZATION_ID

Line 1013: FROM MTL_PARAMETERS

1009: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID))
1010: AND (BIC.TO_END_ITEM_REV_ID IS NULL
1011: OR (NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),
1012: (SELECT STARTING_REVISION
1013: FROM MTL_PARAMETERS
1014: WHERE ORGANIZATION_ID = BET.ORGANIZATION_ID)) <= (SELECT REVISION
1015: FROM MTL_ITEM_REVISIONS_B
1016: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
1017: AND ORGANIZATION_ID = BET.ORGANIZATION_ID

Line 3922: FROM mtl_parameters

3918: -- referenced as the costing organization THEN the is_cost_organization flag is
3919: -- set to 'Y'.
3920:
3921: SELECT count(*) INTO cnt
3922: FROM mtl_parameters
3923: WHERE organization_id = cost_organization_id
3924: AND organization_id = org_id;
3925:
3926: IF (cnt >0) THEN