[Home] [Help]
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;
1133: mtl_parameters mparams,
1134: mtl_system_items_tl mitl,
1135: mtl_item_categories mic,
1136: mtl_units_of_measure muom,
1137: financials_system_params_all fsp,
1138: icx_por_category_data_sources catMap
1139: WHERE mi.inventory_item_id = g_source_ids(j)
1140: AND mi.organization_id = mparams.organization_id
1141: AND (mparams.organization_id = nvl(g_organization_id,mparams.organization_id)
1451: SELECT organization_id, master_organization_id
1452: INTO l_organization_id,l_master_organization_id
1453: FROM(
1454: SELECT mparams.organization_id organization_id, mparams.master_organization_id master_organization_id
1455: FROM mtl_parameters mparams,financials_system_params_all fsp, mtl_system_items_b mtlb
1456: WHERE fsp.ORG_ID = rec_MI.ORG_ID
1457: AND mtlb.inventory_item_id = rec_MI.inventory_item_id
1458: AND mtlb.organization_id = mparams.organization_id
1459: AND (mparams.organization_id = fsp.INVENTORY_ORGANIZATION_ID
1802: mtl_parameters mparams,
1803: mtl_system_items_tl mitl,
1804: mtl_item_categories mic,
1805: mtl_units_of_measure muom,
1806: financials_system_params_all fsp,
1807: icx_por_category_data_sources catMap
1808: WHERE
1809: mi.organization_id = mparams.organization_id
1810: AND (mparams.organization_id = nvl(p_org_id,mparams.organization_id)