DBA Data[Home] [Help]

APPS.AHL_RM_MATERIAL_AS_PVT dependencies on MTL_PARAMETERS

Line 1331: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

1327: CURSOR get_comms_nl_trackable_flag ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
1328: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
1329: IS
1330: SELECT DISTINCT MI.comms_nl_trackable_flag
1331: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
1332: WHERE MP.organization_id = MI.organization_id
1333: AND MI.inventory_item_id = c_inventory_item_id
1334: AND MI.organization_id = c_inventory_org_id
1335: AND MI.enabled_flag = 'Y'

Line 1975: mtl_parameters MP

1971: CURSOR get_org_code ( c_inv_mast_org_id NUMBER )
1972: IS
1973: SELECT DISTINCT ORGANIZATION_CODE
1974: FROM
1975: mtl_parameters MP
1976: WHERE
1977: MP.MASTER_ORGANIZATION_ID = c_inv_mast_org_id AND
1978: MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;
1979: CURSOR get_item_number ( c_inventory_item_id NUMBER, c_inventory_master_org_id NUMBER )