APPS.EGO_CHANGE_USER_ATTRS_PUB dependencies on MTL_PARAMETERS

Line 274: FROM MTL_PARAMETERS MP

270: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Org Code conversion', 2);
271:
272: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
273: SET UAI.ORGANIZATION_ID = (SELECT MP.ORGANIZATION_ID
274: FROM MTL_PARAMETERS MP
275: WHERE MP.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE)
276: WHERE UAI.DATA_SET_ID = p_data_set_id
277: AND UAI.ORGANIZATION_CODE IS NOT NULL
278: AND EXISTS(SELECT MP2.ORGANIZATION_ID

Line 279: FROM MTL_PARAMETERS MP2

275: WHERE MP.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE)
276: WHERE UAI.DATA_SET_ID = p_data_set_id
277: AND UAI.ORGANIZATION_CODE IS NOT NULL
278: AND EXISTS(SELECT MP2.ORGANIZATION_ID
279: FROM MTL_PARAMETERS MP2
280: WHERE MP2.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE);
281:
282: ---------------------------------------------------------------------
283: -- Mark as errors all rows where we didn't get an Organization ID --

Line 1316: from ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP

1312: l_attr_row_table EGO_USER_ATTR_ROW_TABLE;
1313:
1314: cursor chg_csr is
1315: select EEC.CHANGE_ID,EEC.CHANGE_ORDER_TYPE_ID
1316: from ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP
1317: where EEC.CHANGE_MGMT_TYPE_CODE = p_change_mgmt_type_code
1318: AND EEC.CHANGE_NOTICE = p_change_number
1319: AND MP.ORGANIZATION_CODE = p_Organization_Code
1320: AND EEC.ORGANIZATION_ID = MP.ORGANIZATION_ID;

Line 1457: from ENG_CHANGE_LINES EEV,ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP

1453: l_attr_row_table EGO_USER_ATTR_ROW_TABLE;
1454:
1455: cursor chgline_csr is
1456: select EEV.CHANGE_LINE_ID,EEV.CHANGE_TYPE_ID
1457: from ENG_CHANGE_LINES EEV,ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP
1458: where EEC.CHANGE_ID = EEV.CHANGE_ID
1459: AND EEC.CHANGE_NOTICE = p_change_number
1460: AND MP.ORGANIZATION_CODE = p_Organization_Code
1461: AND EEC.ORGANIZATION_ID = MP.ORGANIZATION_ID