DBA Data[Home] [Help]

APPS.RLM_CORE_SV dependencies on MTL_PARAMETERS

Line 1380: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP

1376: x_progress VARCHAR2(3) := '010';
1377: --bug 3639301
1378: CURSOR c IS
1379: SELECT MP.ORGANIZATION_CODE
1380: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP
1381: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
1382: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HOI1.ORG_INFORMATION1 = 'INV'
1383: AND HOI1.ORG_INFORMATION2 = 'Y'
1384: AND ( HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'

Line 1387: v_org_code MTL_PARAMETERS.organization_code%TYPE;

1383: AND HOI1.ORG_INFORMATION2 = 'Y'
1384: AND ( HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
1385: AND HOU.ORGANIZATION_ID = x_ship_from_id;
1386: --
1387: v_org_code MTL_PARAMETERS.organization_code%TYPE;
1388: --
1389: BEGIN
1390: --
1391: --dpush('get_ship_from');