eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PARTS_ORDER dependencies on MTL_PARAMETERS

Line 45: mtl_parameters mp

41: CURSOR unit_price_cur (p_item_id NUMBER, p_source_organization_id NUMBER) IS
42:
43: SELECT cic.item_cost
44: FROM cst_item_costs_for_gl_view cic,
45: mtl_parameters mp
46: WHERE cic.inventory_item_id = p_item_id
47: AND cic.organization_id = mp.cost_organization_id
48: AND cic.inventory_asset_flag = 1
49: AND mp.organization_id= p_source_organization_id;

Line 279: -- from MTL_PARAMETERS for the Destination Organization

275: END;
276: END IF;
277:
278: -- If Expense Account not available in Item Master, get account
279: -- from MTL_PARAMETERS for the Destination Organization
280: IF (l_charge_account IS NULL) THEN
281: BEGIN
282: SELECT expense_account
283: INTO l_charge_account

Line 284: FROM mtl_parameters

280: IF (l_charge_account IS NULL) THEN
281: BEGIN
282: SELECT expense_account
283: INTO l_charge_account
284: FROM mtl_parameters
285: WHERE organization_id = p_destination_organization_id;
286:
287: EXCEPTION
288: WHEN OTHERS THEN

Line 309: FROM mtl_parameters

305: IF l_subinventory_type = 'X' then
306: BEGIN
307: SELECT material_account
308: INTO l_charge_account
309: FROM mtl_parameters
310: WHERE organization_id = p_destination_organization_id;
311: EXCEPTION
312: WHEN OTHERS THEN
313: l_charge_account := 1111;

Line 330: -- for the Organization from MTL_PARAMETERS

326: END;
327: -- If charge account is NULL for the Subinventory, get the default account
328:
329:
330: -- for the Organization from MTL_PARAMETERS
331: IF (l_charge_account is NULL) THEN
332: BEGIN
333: SELECT expense_account
334: INTO l_charge_account

Line 335: FROM mtl_parameters

331: IF (l_charge_account is NULL) THEN
332: BEGIN
333: SELECT expense_account
334: INTO l_charge_account
335: FROM mtl_parameters
336: WHERE organization_id = p_destination_organization_id;
337: EXCEPTION
338: WHEN OTHERS THEN
339: l_charge_account := 1113;

Line 356: -- get it for the Destination Organization from MTL_PARAMETERS

352: l_charge_account := 1114;
353: END;
354:
355: -- If Charge_account is not availabe for the Subinventory,
356: -- get it for the Destination Organization from MTL_PARAMETERS
357: IF (l_charge_account IS NULL) THEN
358: BEGIN
359: SELECT material_account
360: INTO l_charge_account

Line 361: FROM mtl_parameters

357: IF (l_charge_account IS NULL) THEN
358: BEGIN
359: SELECT material_account
360: INTO l_charge_account
361: FROM mtl_parameters
362: WHERE organization_id = p_destination_organization_id;
363: EXCEPTION
364: WHEN OTHERS THEN
365: l_charge_account := 1115;

Line 1199: -- from MTL_PARAMETERS

1195: FROM sys.dual;
1196:
1197: -- Cursor to get Accrual Account ID and Variance Account ID
1198: -- For Destination Type Code INVENTORY get accrual account id
1199: -- from MTL_PARAMETERS
1200: -- Per Requisition Import program (pocis.opc).
1201: CURSOR accrual_account_id_cur (p_destination_organization_id NUMBER) IS
1202: SELECT mp.ap_accrual_account,
1203: mp.invoice_price_var_account

Line 1204: FROM mtl_parameters mp

1200: -- Per Requisition Import program (pocis.opc).
1201: CURSOR accrual_account_id_cur (p_destination_organization_id NUMBER) IS
1202: SELECT mp.ap_accrual_account,
1203: mp.invoice_price_var_account
1204: FROM mtl_parameters mp
1205: WHERE mp.organization_id = p_destination_organization_id;
1206:
1207: -- Get Item Category ID
1208: -- As in Requisition Import

Line 1228: -- from MTL_PARAMETERS for the Item and the Destination Organization

1224:
1225: -- If encumbrance flag is 'Y' get the budget account
1226: -- For Internal Req, Destination Type Code will be INVENTORY
1227: -- Hence, it is assumed that the budget account will come
1228: -- from MTL_PARAMETERS for the Item and the Destination Organization
1229: CURSOR budget_account_cur (p_destination_organization_id NUMBER,
1230: p_item_id NUMBER) IS
1231: SELECT nvl (msi.encumbrance_account,mp.encumbrance_account)
1232: FROM mtl_system_items msi,

Line 1233: mtl_parameters mp

1229: CURSOR budget_account_cur (p_destination_organization_id NUMBER,
1230: p_item_id NUMBER) IS
1231: SELECT nvl (msi.encumbrance_account,mp.encumbrance_account)
1232: FROM mtl_system_items msi,
1233: mtl_parameters mp
1234: WHERE msi.inventory_item_id = p_item_id
1235: AND msi.organization_id = p_destination_organization_id
1236: AND mp.organization_id = msi.organization_id;
1237:

Line 3112: from mtl_parameters

3108: and inventory_item_id = l_line_tbl(i).inventory_item_id;
3109:
3110: select organization_code
3111: into l_line_tbl(i).ATTRIBUTE1 -- taking dummy variable as we are going to throw an error only
3112: from mtl_parameters
3113: where organization_id = l_header_rec.dest_organization_id;
3114:
3115: FND_MESSAGE.SET_TOKEN ('ITM', l_line_tbl(i).item_description, FALSE);
3116: FND_MESSAGE.SET_TOKEN ('ORG', l_line_tbl(i).ATTRIBUTE1, FALSE);

Line 3313: --Destination Organization from MTL_PARAMETERS

3309: Raise INVALID_CHARGE_ACCOUNT;
3310: END IF;
3311:
3312: -- Get Accrual Account ID and Variance Account ID for the
3313: --Destination Organization from MTL_PARAMETERS
3314:
3315: OPEN accrual_account_id_cur (l_header_Rec.dest_organization_id);
3316: FETCH accrual_account_id_cur
3317: INTO l_dist_rec.accrual_account_id,