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

Line 283: from mtl_parameters

279: l_stmt_num := 15;
280:
281: select decode(encumbrance_reversal_flag,1,1,2,0,0)
282: into l_enc_rev
283: from mtl_parameters
284: where organization_id = i_org_id;
285:
286:
287: -- Figure out currency stuff.

Line 894: from mtl_parameters

890: if (i_cost_grp_id = 1) then
891: /* Need to change cst_avg_dist_accts_v to include expense_account */
892: select nvl(expense_account,-1)
893: into l_exp_acct1
894: from mtl_parameters
895: where organization_id = i_org_id;
896: else
897: select nvl(expense_account, -1)
898: into l_exp_acct1

Line 1261: from mtl_parameters

1257: if (i_cost_grp_id = 1) then
1258: /* Need to change cst_avg_dist_accts_v to include expense_account */
1259: select nvl(expense_account,-1)
1260: into l_exp_acct
1261: from mtl_parameters
1262: where organization_id = i_org_id;
1263: else
1264: select nvl(expense_account, -1)
1265: into l_exp_acct

Line 1510: from mtl_parameters

1506: if (i_cost_grp_id = 1) then
1507: /* Need to change cst_avg_dist_accts_v to include expense_account */
1508: select nvl(expense_account,-1)
1509: into l_exp_acct1
1510: from mtl_parameters
1511: where organization_id = i_org_id;
1512: else
1513: select nvl(expense_account, -1)
1514: into l_exp_acct1

Line 1523: from mtl_parameters

1519:
1520: if (i_txfr_cost_grp = 1) then
1521: select nvl(expense_account,-1)
1522: into l_exp_acct2
1523: from mtl_parameters
1524: where organization_id = i_org_id;
1525: else
1526: select nvl(expense_account, -1)
1527: into l_exp_acct2

Line 1700: from mtl_parameters

1696: /* Need to change cst_avg_dist_accts_v to include expense_account */
1697: l_stmt_num := 12;
1698: select nvl(expense_account,-1)
1699: into l_exp_acct
1700: from mtl_parameters
1701: where organization_id = i_org_id;
1702: else
1703: l_stmt_num := 13;
1704: select nvl(expense_account, -1)

Line 1719: FROM mtl_parameters mp, mtl_material_transactions mmt

1715: IF (i_src_type_id = 8 and i_txn_act_id = 1)
1716: THEN
1717: SELECT decode(MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2), 1, 'Y', 'N')
1718: INTO l_pd_xfer_ind
1719: FROM mtl_parameters mp, mtl_material_transactions mmt
1720: WHERE mmt.transaction_id = i_txn_id
1721: AND (mp.organization_id = mmt.organization_id
1722: OR mp.organization_id = mmt.transfer_organization_id);
1723: END IF;

Line 1823: from mtl_parameters

1819: l_stmt_num := 30;
1820:
1821: select ap_accrual_account
1822: into l_acct
1823: from mtl_parameters
1824: where organization_id = i_org_id;
1825: end if;
1826:
1827: l_stmt_num := 35;

Line 1852: mtl_parameters mp

1848:
1849: select nvl(msi.cost_of_sales_account, mp.cost_of_sales_account)
1850: into l_acct
1851: from mtl_system_items msi,
1852: mtl_parameters mp
1853: where msi.organization_id = i_org_id
1854: and msi.inventory_item_id = i_item_id
1855: and mp.organization_id = msi.organization_id;
1856: end if;

Line 1868: FROM mtl_parameters

1864: l_stmt_num := 43;
1865:
1866: SELECT deferred_cogs_account
1867: INTO l_def_cogs_acct_id
1868: FROM mtl_parameters
1869: WHERE organization_id = i_org_id;
1870:
1871: /* Only call Insert_OneSoIssue if the percentage is NULL. */
1872: IF (i_cogs_percentage IS NULL) THEN

Line 1996: MTL_PARAMETERS mp, MTL_PARAMETERS mpx

1992: l_txfr_txn_id,
1993: l_transfer_price,
1994: l_pd_xfer_ind
1995: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1996: MTL_PARAMETERS mp, MTL_PARAMETERS mpx
1997: WHERE mmt.transaction_id = i_txn_id
1998: AND mp.organization_id = mmt.organization_id
1999: AND mpx.organization_id = mmt.transfer_organization_id;
2000:

Line 2410: FROM mtl_parameters mp

2406:
2407: /* OPM INVCONV sschinch check if this is a process discrete transfer */
2408: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)
2409: INTO l_pd_txfr_ind
2410: FROM mtl_parameters mp
2411: WHERE mp.organization_id = i_txn_org_id
2412: OR mp.organization_id = i_txf_org_id;
2413:
2414: SELECT nvl(ap_accrual_account, -1)

Line 2416: FROM mtl_parameters

2412: OR mp.organization_id = i_txf_org_id;
2413:
2414: SELECT nvl(ap_accrual_account, -1)
2415: INTO l_inv_ap_accrual_acct
2416: FROM mtl_parameters
2417: WHERE organization_id = i_org_id;
2418:
2419: IF l_pd_txfr_ind = 1
2420: THEN

Line 2496: from mtl_parameters

2492: if (i_cost_grp_id = 1) then
2493: /* Need to change cst_avg_dist_accts_v to include expense_account */
2494: select nvl(expense_account,l_exp_acct)
2495: into l_exp_acct
2496: from mtl_parameters
2497: where organization_id = i_org_id;
2498: else
2499: select nvl(expense_account, l_exp_acct)
2500: into l_exp_acct

Line 2704: FROM MTL_PARAMETERS

2700: l_stmt_num := 47;
2701: SELECT decode(nvl(cost_group_accounting,0),0,0,
2702: decode(nvl(project_reference_enabled,0),1,1,0))
2703: INTO l_pjm_flg
2704: FROM MTL_PARAMETERS
2705: WHERE organization_id = l_std_org;
2706:
2707: l_stmt_num := 50;
2708: l_subinv := i_subinv;

Line 2739: from mtl_parameters

2735: nvl(expense_account, l_std_exp_acct)
2736: into l_std_mat_acct, l_std_mat_ovhd_acct, l_std_res_acct,
2737: l_std_osp_acct, l_std_ovhd_acct,
2738: l_std_exp_acct
2739: from mtl_parameters
2740: where organization_id = l_std_org;
2741: else
2742: select material_account, material_overhead_account, resource_account,
2743: outside_processing_account, overhead_account,

Line 3700: from mtl_parameters

3696:
3697: if (l_to_cost_grp = 1) then
3698: select nvl(material_account,-1), nvl(material_overhead_account,-1)
3699: into l_acct, l_moh_offset_acct
3700: from mtl_parameters
3701: where organization_id = i_org_id;
3702: else
3703: select nvl(material_account,-1), nvl(material_overhead_account,-1)
3704: into l_acct, l_moh_offset_acct

Line 4130: from mtl_parameters

4126:
4127: if (l_to_cost_grp = 1) then
4128: select nvl(material_account,-1)
4129: into l_acct
4130: from mtl_parameters
4131: where organization_id = i_org_id;
4132: else
4133: select nvl(material_account,-1)
4134: into l_acct

Line 4191: from mtl_parameters

4187:
4188: if (l_to_cost_grp = 1) then
4189: select nvl(material_account,-1)
4190: into l_acct
4191: from mtl_parameters
4192: where organization_id = i_org_id;
4193: else
4194: select nvl(material_account,-1)
4195: into l_acct

Line 4362: from mtl_parameters

4358:
4359: if (i_cost_grp_id = 1) then
4360: select count(*)
4361: into l_acct_exist
4362: from mtl_parameters
4363: where organization_id = i_org_id;
4364: else
4365: select count(*)
4366: into l_acct_exist

Line 4389: from mtl_parameters

4385: l_inv_mat_ovhd_acct,
4386: l_inv_res_acct,
4387: l_inv_osp_acct,
4388: l_inv_ovhd_acct
4389: from mtl_parameters
4390: where organization_id = i_org_id;
4391: else
4392: select nvl(material_account,-1),
4393: nvl(material_overhead_account,-1),

Line 4601: from mtl_parameters

4597: if (l_acct = -1) then
4598: if (i_cost_grp_id = 1) then
4599: select nvl(average_cost_var_account,-1)
4600: into l_acct
4601: from mtl_parameters
4602: where organization_id = i_org_id;
4603: else
4604: select nvl(average_cost_var_account,-1)
4605: into l_acct

Line 4732: from mtl_parameters

4728: if (i_exp_item = 1) then
4729: if (i_cost_grp_id = 1) then
4730: select nvl(expense_account,-1)
4731: into l_exp_acct
4732: from mtl_parameters
4733: where organization_id = i_org_id;
4734: else
4735: select nvl(expense_account, -1)
4736: into l_exp_acct

Line 4751: from mtl_parameters

4747: select primary_cost_method, -- Standard costing orgs will have to call the new inventory_accounts_std() procedure
4748: deferred_cogs_account
4749: into l_cost_method,
4750: l_def_cogs_acct_id
4751: from mtl_parameters
4752: where organization_id = i_org_id;
4753:
4754: /*******************************************************************************
4755: ** Set the account and accounting line type for the offsetting distribution. **

Line 5228: FROM MTL_PARAMETERS

5224: l_stmt_num := 40;
5225: SELECT decode(nvl(cost_group_accounting,0),0,0,
5226: decode(nvl(project_reference_enabled,0),1,1,0))
5227: INTO l_pjm_flg
5228: FROM MTL_PARAMETERS
5229: WHERE organization_id = i_org_id;
5230:
5231: /* Changes for PJM Standard Costing. */
5232: if (l_wms_flg=0 AND l_pjm_flg=0 AND i_subinv is not null) then

Line 5256: FROM mtl_parameters

5252: nvl(resource_account, -1),
5253: nvl(outside_processing_account, -1),
5254: nvl(overhead_account, -1)
5255: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct
5256: FROM mtl_parameters
5257: WHERE organization_id = i_org_id;
5258: else
5259: l_stmt_num := 80;
5260:

Line 5453: from mtl_parameters

5449:
5450: if (i_cost_grp_id = 1) then
5451: select count(*)
5452: into l_acct_exist
5453: from mtl_parameters
5454: where organization_id = i_org_id;
5455: else
5456: select count(*)
5457: into l_acct_exist

Line 5485: from mtl_parameters

5481: l_mat_ovhd_acct,
5482: l_res_acct,
5483: l_osp_acct,
5484: l_ovhd_acct
5485: from mtl_parameters
5486: where organization_id = i_org_id;
5487: else
5488: select nvl(material_account,-1),
5489: nvl(material_overhead_account,-1),

Line 5663: from mtl_parameters

5659: if (l_acct = -1) then
5660: if (i_cost_grp_id = 1) then
5661: select nvl(average_cost_var_account,-1)
5662: into l_acct
5663: from mtl_parameters
5664: where organization_id = i_org_id;
5665: else
5666: select nvl(average_cost_var_account,-1)
5667: into l_acct

Line 5723: -- there are no borrow payback variance account defined in mtl_parameters

5719: end if;
5720:
5721: if (l_acct = -1 AND i_cost_grp_id <> 1) then
5722: -- if cost_grp_id is 1, then payback variance accountS would remain -1, since
5723: -- there are no borrow payback variance account defined in mtl_parameters
5724: l_stmt_num := 110;
5725: if cost_element = 1 then
5726: select nvl(payback_mat_var_account,-1)
5727: into l_acct

Line 5900: from mtl_parameters

5896: -- the costing method.
5897: l_stmt_num := 0;
5898: select primary_cost_method
5899: into l_cost_method
5900: from mtl_parameters
5901: where organization_id = i_org_id;
5902:
5903: if(i_elemental = 1) then
5904:

Line 6597: from mtl_parameters

6593:
6594: l_stmt_num := 1;
6595: select decode(encumbrance_reversal_flag,1,1,2,0,0)
6596: into l_enc_rev
6597: from mtl_parameters
6598: where organization_id = i_org_id;
6599:
6600: l_stmt_num := 2;
6601: IF(l_enc_rev = 1) THEN

Line 7210: FROM MTL_PARAMETERS

7206:
7207: SELECT decode(nvl(cost_group_accounting,0),0,0,
7208: decode(nvl(project_reference_enabled,0),1,1,0))
7209: INTO pjm_flg
7210: FROM MTL_PARAMETERS
7211: WHERE organization_id = org_id;
7212:
7213: fnd_file.put_line(fnd_file.log, 'wms_flg: ' || wms_flg || ' pjm_flg: ' || pjm_flg);
7214:

Line 7233: from mtl_parameters

7229: EXEC SQL select
7230: primary_cost_method
7231: INTO
7232: :rec_p_cst_type
7233: from mtl_parameters
7234: where organization_id = :txf_org_id;
7235:
7236: l_stmt_num := 80;
7237: }

Line 7299: from mtl_parameters

7295: enc_rev,
7296: mat_acct, mat_ovhd_acct, res_acct,
7297: osp_acct, ovhd_acct,
7298: exp_acct
7299: from mtl_parameters
7300: where organization_id = org_id;
7301:
7302:
7303: /*----------------------------------------------------------------------+

Line 7367: -- We've already populated accounts from mtl_parameters above (stmt 130)

7363: l_stmt_num := 190;
7364: if subinv is null
7365: then
7366: -- l_stmt_num := 191;
7367: -- We've already populated accounts from mtl_parameters above (stmt 130)
7368: NULL;
7369: else
7370: l_stmt_num := 192;
7371: select material_account, material_overhead_account, resource_account,

Line 7392: from mtl_parameters

7388: nvl(expense_account, exp_acct)
7389: into mat_acct, mat_ovhd_acct, res_acct,
7390: osp_acct, ovhd_acct,
7391: exp_acct
7392: from mtl_parameters
7393: where organization_id = org_id;
7394:
7395: else
7396: l_stmt_num := 230;

Line 7575: FROM mtl_interorg_parameters mip, mtl_parameters mp, mtl_material_transactions mmt

7571: io_pay_acct,
7572: io_ppv_acct,
7573: acv_acct, /* overwrite sending acv_acct */
7574: interorg_profit_acct
7575: FROM mtl_interorg_parameters mip, mtl_parameters mp, mtl_material_transactions mmt
7576: WHERE mip.from_organization_id = from_org
7577: AND mip.to_organization_id = to_org
7578: AND mp.organization_id = org_id
7579: AND mmt.transaction_id = trans_id;

Line 7615: FROM mtl_parameters

7611: if (cg_id = 1)
7612: then
7613: SELECT nvl(purchase_price_var_account, io_ppv_acct)
7614: INTO io_ppv_acct
7615: FROM mtl_parameters
7616: WHERE organization_id = org_id;
7617: else
7618: l_stmt_num := 612;
7619:

Line 9658: mtl_parameters b

9654: ,l_mta_rec.ENCUMBRANCE_TYPE_ID
9655: ,l_mta_rec.REPETITIVE_SCHEDULE_ID
9656: ,l_mta_rec.USSGL_TRANSACTION_CODE
9657: FROM mtl_transaction_accounts a,
9658: mtl_parameters b
9659: WHERE a.transaction_id = i_txn_id
9660: AND a.organization_id = i_org_id
9661: AND b.organization_id = a.organization_id;
9662: