APPS.EGO_ITEM_WS_PVT dependencies on MTL_PARAMETERS

Line 1364: MTL_PARAMETERS MP ,

1360: SYSDATE
1361: FROM
1362: MTL_CROSS_REFERENCES EgoGtinEO ,
1363: MTL_SYSTEM_ITEMS_B MSIB ,
1364: MTL_PARAMETERS MP ,
1365: ( SELECT DISTINCT MCR1.CROSS_REFERENCE ,
1366: MSIK.INVENTORY_ITEM_ID ,
1367: MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER ,
1368: MSIK.ORGANIZATION_ID MASTER_ORGANIZATION_ID,

Line 1372: MTL_PARAMETERS MP1

1368: MSIK.ORGANIZATION_ID MASTER_ORGANIZATION_ID,
1369: MSIK.PRIMARY_UOM_CODE
1370: FROM MTL_CROSS_REFERENCES_B MCR1,
1371: MTL_SYSTEM_ITEMS_KFV MSIK ,
1372: MTL_PARAMETERS MP1
1373: WHERE MCR1.CROSS_REFERENCE_TYPE = 'GTIN'
1374: AND MCR1.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
1375: AND MSIK.ORGANIZATION_ID = MP1.MASTER_ORGANIZATION_ID
1376: AND MSIK.PRIMARY_UOM_CODE = trim(MCR1.UOM_CODE)

Line 4339: from mtl_parameters

4335: BEGIN
4336: IF (p_org_id <> -1) THEN
4337: select organization_id
4338: INTO p_organization_id
4339: from mtl_parameters
4340: WHERE organization_id = p_org_id;
4341:
4342: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4343: p_odi_session_id => p_odi_session_id,

Line 4350: from mtl_parameters

4346: p_param_value => p_org_id );
4347: ELSE
4348: select organization_id
4349: INTO p_organization_id
4350: from mtl_parameters
4351: WHERE organization_code = p_org_code;
4352:
4353: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4354: p_odi_session_id => p_odi_session_id,