DBA Data[Home] [Help]

APPS.ICX_ITEM_DIAG_PVT dependencies on HR_OPERATING_UNITS

Line 370: from financials_system_params_all fsp, hr_operating_units org ,org_organization_definitions org1 ,mtl_parameters mparams

366: cursor OU_INV is
367: select ORG_ID, org.SHORT_CODE OU_CODE, org.NAME OU_NAME ,
368: fsp.INVENTORY_ORGANIZATION_ID inventory_ORGANIZATION, org1.ORGANIZATION_CODE INV_ORG_CODE,org1.ORGANIZATION_NAME INV_ORG_NAME
369: ,mparams.MASTER_ORGANIZATION_ID
370: from financials_system_params_all fsp, hr_operating_units org ,org_organization_definitions org1 ,mtl_parameters mparams
371: where fsp.org_id =ICX_ITEM_DIAG_PVT.g_org_id
372: and fsp.org_id =org.ORGANIZATION_ID
373: and fsp.INVENTORY_ORGANIZATION_ID=org1.ORGANIZATION_ID
374: AND mparams.organization_id=fsp.INVENTORY_ORGANIZATION_ID;