APPS.INV_VIEW_MTL_TXN dependencies on MTL_PARAMETERS

Line 133: , MTL_PARAMETERS MP

129: BEGIN
130: SELECT (MP.organization_code||'-'||HAOU.name)
131: INTO x_owning_organization_name
132: FROM HR_ALL_ORGANIZATION_UNITS HAOU
133: , MTL_PARAMETERS MP
134: WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
135: AND HAOU.ORGANIZATION_ID = p_owning_organization_id;
136: EXCEPTION
137: WHEN OTHERS THEN

Line 165: , MTL_PARAMETERS MP

161: BEGIN
162: SELECT (MP.organization_code||'-'||HAOU.name)
163: INTO x_xfr_owning_organization_name
164: FROM HR_ALL_ORGANIZATION_UNITS HAOU
165: , MTL_PARAMETERS MP
166: WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
167: AND HAOU.ORGANIZATION_ID = p_xfr_owning_organization_id;
168: EXCEPTION
169: WHEN OTHERS THEN

Line 192: , MTL_PARAMETERS MP

188: BEGIN
189: SELECT (MP.organization_code||'-'||HAOU.name), NULL
190: INTO x_supplier_site_name, x_supplier
191: FROM HR_ALL_ORGANIZATION_UNITS HAOU
192: , MTL_PARAMETERS MP
193: WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
194: AND HAOU.ORGANIZATION_ID = p_planning_organization_id;
195: EXCEPTION
196: WHEN OTHERS THEN

Line 313: FROM MTL_PARAMETERS

309: IF p_TRANSFER_ORGANIZATION_ID IS NOT NULL THEN
310: BEGIN
311: SELECT DISTINCT ORGANIZATION_CODE
312: INTO x_TRANSFER_ORGANIZATION_NAME
313: FROM MTL_PARAMETERS
314: WHERE ORGANIZATION_ID = p_TRANSFER_ORGANIZATION_ID;
315: EXCEPTION
316: WHEN OTHERS THEN
317: NULL;