APPS.EGO_ITEM_PUB dependencies on MTL_PARAMETERS

Line 3611: and exists (select 1 from mtl_parameters

3607: IS
3608: SELECT ORGANIZATION_ID
3609: FROM MTL_SYSTEM_ITEMS_VL msi
3610: WHERE msi.INVENTORY_ITEM_ID = v_inventory_item_id
3611: and exists (select 1 from mtl_parameters
3612: where organization_id=msi.organization_id
3613: and master_organization_id=v_master_organization_id);
3614:
3615: L_SYSDATE DATE := Sysdate;

Line 3897: FROM MTL_PARAMETERS MP

3893: FUNCTION Get_Master_Organization_Id(P_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS
3894: L_MASTER_ORGANIZATION_ID NUMBER;
3895: BEGIN
3896: SELECT MP.MASTER_ORGANIZATION_ID INTO L_MASTER_ORGANIZATION_ID
3897: FROM MTL_PARAMETERS MP
3898: WHERE MP.ORGANIZATION_ID = P_ORGANIZATION_ID;
3899:
3900: RETURN L_MASTER_ORGANIZATION_ID;
3901:

Line 4609: FROM MTL_PARAMETERS

4605: BEGIN
4606: IF p_organization_id IS NULL THEN
4607: IF p_organization_code IS NOT NULL THEN
4608: SELECT ORGANIZATION_ID INTO l_organization_id
4609: FROM MTL_PARAMETERS
4610: WHERE ORGANIZATION_CODE = p_organization_code;
4611: ELSE
4612: RAISE INVALID_ORG;
4613: END IF;

Line 4616: FROM MTL_PARAMETERS

4612: RAISE INVALID_ORG;
4613: END IF;
4614: ELSE
4615: SELECT ORGANIZATION_ID INTO l_organization_id
4616: FROM MTL_PARAMETERS
4617: WHERE ORGANIZATION_ID = p_organization_id;
4618: END IF;
4619:
4620: EXCEPTION