DBA Data[Home] [Help]

APPS.INV_COPY_ORGANIZATION_REPORT dependencies on MTL_PARAMETERS

Line 1596: , MTL_PARAMETERS mp

1592: )
1593: IS
1594: SELECT mp.ORGANIZATION_CODE
1595: FROM MTL_INTERORG_PARAMETERS mip1
1596: , MTL_PARAMETERS mp
1597: WHERE mip1.FROM_ORGANIZATION_ID = p_model_org_id
1598: AND mp.ORGANIZATION_ID = mip1.TO_ORGANIZATION_ID
1599: AND NOT EXISTS
1600: ( SELECT 'x'

Line 1612: , MTL_PARAMETERS mp

1608: )
1609: IS
1610: SELECT mp.ORGANIZATION_CODE
1611: FROM MTL_INTERORG_PARAMETERS mip1
1612: , MTL_PARAMETERS mp
1613: WHERE mip1.TO_ORGANIZATION_ID = p_model_org_id
1614: AND mp.ORGANIZATION_ID = mip1.FROM_ORGANIZATION_ID
1615: AND NOT EXISTS
1616: ( SELECT 'x'

Line 4205: FROM mtl_parameters

4201: l_api_name VARCHAR2(100):=' Get_Organization_Id ';
4202: BEGIN
4203: SELECT organization_id
4204: INTO l_org_id
4205: FROM mtl_parameters
4206: WHERE organization_code = p_org_code;
4207:
4208: RETURN l_org_id;
4209: EXCEPTION