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 292: from mtl_parameters

288: primary_cost_method
289: into l_enc_rev,
290: l_enc_org_id,
291: l_enc_org_cost_method
292: from mtl_parameters
293: where ( organization_id = i_org_id
294: AND l_src_type_id = 1 )
295: OR (organization_id = i_org_id
296: AND l_txn_act_id = 29 and l_src_type_id = 7 )

Line 313: from mtl_parameters

309: primary_cost_method
310: into l_enc_rev,
311: l_enc_org_id,
312: l_enc_org_cost_method
313: from mtl_parameters
314: where organization_id = i_org_id;
315:
316: END IF;
317:

Line 985: from mtl_parameters

981: if (i_cost_grp_id = 1) then
982: /* Need to change cst_avg_dist_accts_v to include expense_account */
983: select nvl(expense_account,-1)
984: into l_exp_acct1
985: from mtl_parameters
986: where organization_id = i_org_id;
987: else
988: select nvl(expense_account, -1)
989: into l_exp_acct1

Line 1352: from mtl_parameters

1348: if (i_cost_grp_id = 1) then
1349: /* Need to change cst_avg_dist_accts_v to include expense_account */
1350: select nvl(expense_account,-1)
1351: into l_exp_acct
1352: from mtl_parameters
1353: where organization_id = i_org_id;
1354: else
1355: select nvl(expense_account, -1)
1356: into l_exp_acct

Line 1601: from mtl_parameters

1597: if (i_cost_grp_id = 1) then
1598: /* Need to change cst_avg_dist_accts_v to include expense_account */
1599: select nvl(expense_account,-1)
1600: into l_exp_acct1
1601: from mtl_parameters
1602: where organization_id = i_org_id;
1603: else
1604: select nvl(expense_account, -1)
1605: into l_exp_acct1

Line 1614: from mtl_parameters

1610:
1611: if (i_txfr_cost_grp = 1) then
1612: select nvl(expense_account,-1)
1613: into l_exp_acct2
1614: from mtl_parameters
1615: where organization_id = i_org_id;
1616: else
1617: select nvl(expense_account, -1)
1618: into l_exp_acct2

Line 1791: from mtl_parameters

1787: /* Need to change cst_avg_dist_accts_v to include expense_account */
1788: l_stmt_num := 12;
1789: select nvl(expense_account,-1)
1790: into l_exp_acct
1791: from mtl_parameters
1792: where organization_id = i_org_id;
1793: else
1794: l_stmt_num := 13;
1795: select nvl(expense_account, -1)

Line 1810: FROM mtl_parameters mp, mtl_material_transactions mmt

1806: IF (i_src_type_id = 8 and i_txn_act_id = 1)
1807: THEN
1808: SELECT decode(MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2), 1, 'Y', 'N')
1809: INTO l_pd_xfer_ind
1810: FROM mtl_parameters mp, mtl_material_transactions mmt
1811: WHERE mmt.transaction_id = i_txn_id
1812: AND (mp.organization_id = mmt.organization_id
1813: OR mp.organization_id = mmt.transfer_organization_id);
1814: END IF;

Line 1914: from mtl_parameters

1910: l_stmt_num := 30;
1911:
1912: select ap_accrual_account
1913: into l_acct
1914: from mtl_parameters
1915: where organization_id = i_org_id;
1916: end if;
1917:
1918: l_stmt_num := 35;

Line 1943: mtl_parameters mp

1939:
1940: select nvl(msi.cost_of_sales_account, mp.cost_of_sales_account)
1941: into l_acct
1942: from mtl_system_items msi,
1943: mtl_parameters mp
1944: where msi.organization_id = i_org_id
1945: and msi.inventory_item_id = i_item_id
1946: and mp.organization_id = msi.organization_id;
1947: end if;

Line 1959: FROM mtl_parameters

1955: l_stmt_num := 43;
1956:
1957: SELECT deferred_cogs_account
1958: INTO l_def_cogs_acct_id
1959: FROM mtl_parameters
1960: WHERE organization_id = i_org_id;
1961:
1962: /* Only call Insert_OneSoIssue if the percentage is NULL. */
1963: IF (i_cogs_percentage IS NULL) THEN

Line 2087: MTL_PARAMETERS mp, MTL_PARAMETERS mpx

2083: l_txfr_txn_id,
2084: l_transfer_price,
2085: l_pd_xfer_ind
2086: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2087: MTL_PARAMETERS mp, MTL_PARAMETERS mpx
2088: WHERE mmt.transaction_id = i_txn_id
2089: AND mp.organization_id = mmt.organization_id
2090: AND mpx.organization_id = mmt.transfer_organization_id;
2091:

Line 2501: FROM mtl_parameters mp

2497:
2498: /* OPM INVCONV sschinch check if this is a process discrete transfer */
2499: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)
2500: INTO l_pd_txfr_ind
2501: FROM mtl_parameters mp
2502: WHERE mp.organization_id = i_txn_org_id
2503: OR mp.organization_id = i_txf_org_id;
2504:
2505: SELECT nvl(ap_accrual_account, -1)

Line 2507: FROM mtl_parameters

2503: OR mp.organization_id = i_txf_org_id;
2504:
2505: SELECT nvl(ap_accrual_account, -1)
2506: INTO l_inv_ap_accrual_acct
2507: FROM mtl_parameters
2508: WHERE organization_id = i_org_id;
2509:
2510: IF l_pd_txfr_ind = 1
2511: THEN

Line 2587: from mtl_parameters

2583: if (i_cost_grp_id = 1) then
2584: /* Need to change cst_avg_dist_accts_v to include expense_account */
2585: select nvl(expense_account,l_exp_acct)
2586: into l_exp_acct
2587: from mtl_parameters
2588: where organization_id = i_org_id;
2589: else
2590: select nvl(expense_account, l_exp_acct)
2591: into l_exp_acct

Line 2795: FROM MTL_PARAMETERS

2791: l_stmt_num := 47;
2792: SELECT decode(nvl(cost_group_accounting,0),0,0,
2793: decode(nvl(project_reference_enabled,0),1,1,0))
2794: INTO l_pjm_flg
2795: FROM MTL_PARAMETERS
2796: WHERE organization_id = l_std_org;
2797:
2798: l_stmt_num := 50;
2799: l_subinv := i_subinv;

Line 2830: from mtl_parameters

2826: nvl(expense_account, l_std_exp_acct)
2827: into l_std_mat_acct, l_std_mat_ovhd_acct, l_std_res_acct,
2828: l_std_osp_acct, l_std_ovhd_acct,
2829: l_std_exp_acct
2830: from mtl_parameters
2831: where organization_id = l_std_org;
2832: else
2833: select material_account, material_overhead_account, resource_account,
2834: outside_processing_account, overhead_account,

Line 3791: from mtl_parameters

3787:
3788: if (l_to_cost_grp = 1) then
3789: select nvl(material_account,-1), nvl(material_overhead_account,-1)
3790: into l_acct, l_moh_offset_acct
3791: from mtl_parameters
3792: where organization_id = i_org_id;
3793: else
3794: select nvl(material_account,-1), nvl(material_overhead_account,-1)
3795: into l_acct, l_moh_offset_acct

Line 4221: from mtl_parameters

4217:
4218: if (l_to_cost_grp = 1) then
4219: select nvl(material_account,-1)
4220: into l_acct
4221: from mtl_parameters
4222: where organization_id = i_org_id;
4223: else
4224: select nvl(material_account,-1)
4225: into l_acct

Line 4282: from mtl_parameters

4278:
4279: if (l_to_cost_grp = 1) then
4280: select nvl(material_account,-1)
4281: into l_acct
4282: from mtl_parameters
4283: where organization_id = i_org_id;
4284: else
4285: select nvl(material_account,-1)
4286: into l_acct

Line 4453: from mtl_parameters

4449:
4450: if (i_cost_grp_id = 1) then
4451: select count(*)
4452: into l_acct_exist
4453: from mtl_parameters
4454: where organization_id = i_org_id;
4455: else
4456: select count(*)
4457: into l_acct_exist

Line 4480: from mtl_parameters

4476: l_inv_mat_ovhd_acct,
4477: l_inv_res_acct,
4478: l_inv_osp_acct,
4479: l_inv_ovhd_acct
4480: from mtl_parameters
4481: where organization_id = i_org_id;
4482: else
4483: select nvl(material_account,-1),
4484: nvl(material_overhead_account,-1),

Line 4692: from mtl_parameters

4688: if (l_acct = -1) then
4689: if (i_cost_grp_id = 1) then
4690: select nvl(average_cost_var_account,-1)
4691: into l_acct
4692: from mtl_parameters
4693: where organization_id = i_org_id;
4694: else
4695: select nvl(average_cost_var_account,-1)
4696: into l_acct

Line 4823: from mtl_parameters

4819: if (i_exp_item = 1) then
4820: if (i_cost_grp_id = 1) then
4821: select nvl(expense_account,-1)
4822: into l_exp_acct
4823: from mtl_parameters
4824: where organization_id = i_org_id;
4825: else
4826: select nvl(expense_account, -1)
4827: into l_exp_acct

Line 4842: from mtl_parameters

4838: select primary_cost_method, -- Standard costing orgs will have to call the new inventory_accounts_std() procedure
4839: deferred_cogs_account
4840: into l_cost_method,
4841: l_def_cogs_acct_id
4842: from mtl_parameters
4843: where organization_id = i_org_id;
4844:
4845: /*******************************************************************************
4846: ** Set the account and accounting line type for the offsetting distribution. **

Line 5320: FROM MTL_PARAMETERS

5316: l_stmt_num := 40;
5317: SELECT decode(nvl(cost_group_accounting,0),0,0,
5318: decode(nvl(project_reference_enabled,0),1,1,0))
5319: INTO l_pjm_flg
5320: FROM MTL_PARAMETERS
5321: WHERE organization_id = i_org_id;
5322:
5323: /* Changes for PJM Standard Costing. */
5324: if (l_wms_flg=0 AND l_pjm_flg=0 AND i_subinv is not null) then

Line 5348: FROM mtl_parameters

5344: nvl(resource_account, -1),
5345: nvl(outside_processing_account, -1),
5346: nvl(overhead_account, -1)
5347: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct
5348: FROM mtl_parameters
5349: WHERE organization_id = i_org_id;
5350: else
5351: l_stmt_num := 80;
5352:

Line 5545: from mtl_parameters

5541:
5542: if (i_cost_grp_id = 1) then
5543: select count(*)
5544: into l_acct_exist
5545: from mtl_parameters
5546: where organization_id = i_org_id;
5547: else
5548: select count(*)
5549: into l_acct_exist

Line 5577: from mtl_parameters

5573: l_mat_ovhd_acct,
5574: l_res_acct,
5575: l_osp_acct,
5576: l_ovhd_acct
5577: from mtl_parameters
5578: where organization_id = i_org_id;
5579: else
5580: select nvl(material_account,-1),
5581: nvl(material_overhead_account,-1),

Line 5755: from mtl_parameters

5751: if (l_acct = -1) then
5752: if (i_cost_grp_id = 1) then
5753: select nvl(average_cost_var_account,-1)
5754: into l_acct
5755: from mtl_parameters
5756: where organization_id = i_org_id;
5757: else
5758: select nvl(average_cost_var_account,-1)
5759: into l_acct

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

5811: end if;
5812:
5813: if (l_acct = -1 AND i_cost_grp_id <> 1) then
5814: -- if cost_grp_id is 1, then payback variance accountS would remain -1, since
5815: -- there are no borrow payback variance account defined in mtl_parameters
5816: l_stmt_num := 110;
5817: if cost_element = 1 then
5818: select nvl(payback_mat_var_account,-1)
5819: into l_acct

Line 5992: from mtl_parameters

5988: -- the costing method.
5989: l_stmt_num := 0;
5990: select primary_cost_method
5991: into l_cost_method
5992: from mtl_parameters
5993: where organization_id = i_org_id;
5994:
5995: if(i_elemental = 1) then
5996:

Line 6718: from mtl_parameters

6714:
6715: l_stmt_num := 1;
6716: select decode(encumbrance_reversal_flag,1,1,2,0,0)
6717: into l_enc_rev
6718: from mtl_parameters
6719: where organization_id = i_org_id;
6720:
6721: l_stmt_num := 2;
6722: IF(l_enc_rev = 1) THEN

Line 7409: FROM MTL_PARAMETERS

7405:
7406: SELECT decode(nvl(cost_group_accounting,0),0,0,
7407: decode(nvl(project_reference_enabled,0),1,1,0))
7408: INTO pjm_flg
7409: FROM MTL_PARAMETERS
7410: WHERE organization_id = org_id;
7411:
7412: fnd_file.put_line(fnd_file.log, 'wms_flg: ' || wms_flg || ' pjm_flg: ' || pjm_flg);
7413:

Line 7432: from mtl_parameters

7428: EXEC SQL select
7429: primary_cost_method
7430: INTO
7431: :rec_p_cst_type
7432: from mtl_parameters
7433: where organization_id = :txf_org_id;
7434:
7435: l_stmt_num := 80;
7436: }

Line 7498: from mtl_parameters

7494: enc_rev,
7495: mat_acct, mat_ovhd_acct, res_acct,
7496: osp_acct, ovhd_acct,
7497: exp_acct
7498: from mtl_parameters
7499: where organization_id = org_id;
7500:
7501:
7502: /*----------------------------------------------------------------------+

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

7562: l_stmt_num := 190;
7563: if subinv is null
7564: then
7565: -- l_stmt_num := 191;
7566: -- We've already populated accounts from mtl_parameters above (stmt 130)
7567: NULL;
7568: else
7569: l_stmt_num := 192;
7570: select material_account, material_overhead_account, resource_account,

Line 7591: from mtl_parameters

7587: nvl(expense_account, exp_acct)
7588: into mat_acct, mat_ovhd_acct, res_acct,
7589: osp_acct, ovhd_acct,
7590: exp_acct
7591: from mtl_parameters
7592: where organization_id = org_id;
7593:
7594: else
7595: l_stmt_num := 230;

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

7770: io_pay_acct,
7771: io_ppv_acct,
7772: acv_acct, /* overwrite sending acv_acct */
7773: interorg_profit_acct
7774: FROM mtl_interorg_parameters mip, mtl_parameters mp, mtl_material_transactions mmt
7775: WHERE mip.from_organization_id = from_org
7776: AND mip.to_organization_id = to_org
7777: AND mp.organization_id = org_id
7778: AND mmt.transaction_id = trans_id;

Line 7814: FROM mtl_parameters

7810: if (cg_id = 1)
7811: then
7812: SELECT nvl(purchase_price_var_account, io_ppv_acct)
7813: INTO io_ppv_acct
7814: FROM mtl_parameters
7815: WHERE organization_id = org_id;
7816: else
7817: l_stmt_num := 612;
7818:

Line 9861: mtl_parameters b

9857: ,l_mta_rec.ENCUMBRANCE_TYPE_ID
9858: ,l_mta_rec.REPETITIVE_SCHEDULE_ID
9859: ,l_mta_rec.USSGL_TRANSACTION_CODE
9860: FROM mtl_transaction_accounts a,
9861: mtl_parameters b
9862: WHERE a.transaction_id = i_txn_id
9863: AND a.organization_id = i_org_id
9864: AND b.organization_id = a.organization_id;
9865: