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.PO_CREATE_REQUISITION_SV dependencies on MTL_PARAMETERS

Line 44: mtl_parameters mp

40: -- Get Unit Price for Internal Requsitions
41: CURSOR unit_price_cur (p_item_id NUMBER, p_source_organization_id NUMBER) IS
42: SELECT cic.item_cost
43: FROM cst_item_costs_for_gl_view cic,
44: mtl_parameters mp
45: WHERE cic.inventory_item_id = p_item_id
46: AND cic.organization_id = mp.cost_organization_id
47: AND cic.inventory_asset_flag = 1
48: AND mp.organization_id= p_source_organization_id;

Line 61: mtl_parameters mp,

57: trunc(sysdate),
58: psp.DEFAULT_RATE_TYPE,
59: 30),10)
60: FROM cst_item_costs_for_gl_view cic,
61: mtl_parameters mp,
62: po_system_parameters psp
63: WHERE cic.inventory_item_id = p_item_id
64: AND cic.organization_id = mp.cost_organization_id
65: AND cic.inventory_asset_flag = 1

Line 351: -- from MTL_PARAMETERS for the Destination Organization

347: PO_LOG.stmt(d_module_base,d_progress,'l_charge_account',l_charge_account);
348: END IF;
349:
350: -- If Expense Account not available in Item Master, get account
351: -- from MTL_PARAMETERS for the Destination Organization
352: IF (l_charge_account IS NULL) THEN
353: BEGIN
354: d_progress := 90;
355: SELECT expense_account

Line 357: FROM mtl_parameters

353: BEGIN
354: d_progress := 90;
355: SELECT expense_account
356: INTO l_charge_account
357: FROM mtl_parameters
358: WHERE organization_id = p_destination_organization_id;
359: EXCEPTION
360: WHEN OTHERS THEN
361: NULL;

Line 392: FROM mtl_parameters

388: BEGIN
389: d_progress := 140;
390: SELECT material_account
391: INTO l_charge_account
392: FROM mtl_parameters
393: WHERE organization_id = p_destination_organization_id;
394: EXCEPTION
395: WHEN OTHERS THEN
396: NULL;

Line 424: -- for the Organization from MTL_PARAMETERS

420: PO_LOG.stmt(d_module_base,d_progress,'l_charge_account',l_charge_account);
421: END IF;
422:
423: -- If charge account is NULL for the Subinventory, get the default account
424: -- for the Organization from MTL_PARAMETERS
425: IF (l_charge_account is NULL) THEN
426: BEGIN
427: d_progress := 180;
428: SELECT expense_account

Line 430: FROM mtl_parameters

426: BEGIN
427: d_progress := 180;
428: SELECT expense_account
429: INTO l_charge_account
430: FROM mtl_parameters
431: WHERE organization_id = p_destination_organization_id;
432: EXCEPTION
433: WHEN OTHERS THEN
434: NULL;

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

459: PO_LOG.stmt(d_module_base,d_progress,'l_charge_account',l_charge_account);
460: END IF;
461:
462: -- If Charge_account is not availabe for the Subinventory,
463: -- get it for the Destination Organization from MTL_PARAMETERS
464: IF (l_charge_account IS NULL) THEN
465: BEGIN
466: d_progress := 220;
467: SELECT material_account

Line 469: FROM mtl_parameters

465: BEGIN
466: d_progress := 220;
467: SELECT material_account
468: INTO l_charge_account
469: FROM mtl_parameters
470: WHERE organization_id = p_destination_organization_id;
471: EXCEPTION
472: WHEN OTHERS THEN
473: NULL;

Line 682: -- from MTL_PARAMETERS

678: FROM sys.dual;
679:
680: -- Cursor to get Accrual Account ID and Variance Account ID
681: -- For Destination Type Code INVENTORY get accrual account id
682: -- from MTL_PARAMETERS
683: -- Per Requisition Import program (pocis.opc).
684: CURSOR accrual_account_id_cur (p_destination_organization_id NUMBER) IS
685: SELECT mp.ap_accrual_account,
686: mp.invoice_price_var_account

Line 687: FROM mtl_parameters mp

683: -- Per Requisition Import program (pocis.opc).
684: CURSOR accrual_account_id_cur (p_destination_organization_id NUMBER) IS
685: SELECT mp.ap_accrual_account,
686: mp.invoice_price_var_account
687: FROM mtl_parameters mp
688: WHERE mp.organization_id = p_destination_organization_id;
689:
690: -- Get Default Line Type
691: CURSOR line_type_cur (p_org_id NUMBER) IS

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

743:
744: -- If encumbrance flag is 'Y' get the budget account
745: -- For Internal Req, Destination Type Code will be INVENTORY
746: -- Hence, it is assumed that the budget account will come
747: -- from MTL_PARAMETERS for the Item and the Destination Organization
748: CURSOR budget_account_cur (p_destination_organization_id NUMBER,
749: p_item_id NUMBER) IS
750: SELECT nvl (msi.encumbrance_account,mp.encumbrance_account)
751: FROM mtl_system_items msi,

Line 752: mtl_parameters mp

748: CURSOR budget_account_cur (p_destination_organization_id NUMBER,
749: p_item_id NUMBER) IS
750: SELECT nvl (msi.encumbrance_account,mp.encumbrance_account)
751: FROM mtl_system_items msi,
752: mtl_parameters mp
753: WHERE msi.inventory_item_id = p_item_id
754: AND msi.organization_id = p_destination_organization_id
755: AND mp.organization_id = msi.organization_id;
756:

Line 1376: --Destination Organization from MTL_PARAMETERS

1372: Raise INVALID_CHARGE_ACCOUNT;
1373: END IF;
1374:
1375: -- Get Accrual Account ID and Variance Account ID for the
1376: --Destination Organization from MTL_PARAMETERS
1377:
1378: OPEN accrual_account_id_cur (l_line_tbl(i).destination_organization_id);
1379: FETCH accrual_account_id_cur
1380: INTO l_dist_rec.accrual_account_id,