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

Line 92: FROM mtl_parameters mp, mtl_material_transactions mmt

88:
89: /* INVCONV sschinch Check if this transaction is a process discrete transfer */
90: SELECT MOD(SUM(DECODE(mp.process_enabled_flag, 'Y', 1, 2)), 2)
91: INTO l_pd_txfr_ind
92: FROM mtl_parameters mp, mtl_material_transactions mmt
93: WHERE mmt.transaction_id = i_txn_id
94: AND (mmt.organization_id = mp.organization_id
95: OR mmt.transfer_organization_id = mp.organization_id);
96:

Line 2950: from mtl_parameters

2946: /* Get the Default MOH sub element of the organization*/
2947:
2948: select DEFAULT_MATL_OVHD_COST_ID
2949: into l_default_MOH_subelement
2950: from mtl_parameters
2951: where organization_id= I_ORG_ID;
2952:
2953: IF g_debug = 'Y' THEN
2954: fnd_file.put_line(fnd_file.log, 'Apply_Material_Overhead <<<');

Line 4183: mtl_parameters mp

4179: UPDATE mtl_material_transactions mmt
4180: SET prior_costed_quantity = (
4181: SELECT cql.layer_quantity - mmt.primary_quantity
4182: FROM cst_quantity_layers cql,
4183: mtl_parameters mp
4184: WHERE cql.organization_id = i_org_id
4185: AND cql.inventory_item_id = l_item_id
4186: AND cql.cost_group_id = mp.default_cost_group_id
4187: AND mp.organization_id = i_org_id

Line 4193: mtl_parameters mp

4189: WHERE mmt.transaction_id = i_txn_id
4190: AND EXISTS (
4191: SELECT 'X'
4192: FROM cst_quantity_layers cql,
4193: mtl_parameters mp
4194: WHERE cql.organization_id = i_org_id
4195: AND cql.inventory_item_id = l_item_id
4196: AND cql.cost_group_id = mp.default_cost_group_id
4197: AND mp.organization_id = i_org_id

Line 4343: from mtl_parameters

4339: /* Get the Default MOH sub element of the organization*/
4340:
4341: select DEFAULT_MATL_OVHD_COST_ID
4342: into l_default_MOH_subelement
4343: from mtl_parameters
4344: where organization_id= I_ORG_ID;
4345:
4346: IF g_debug = 'Y' THEN
4347: fnd_file.put_line(fnd_file.log, '>>>>Inside Update_Item_Cost');

Line 4690: from mtl_parameters

4686:
4687: l_stmt_num := 7;
4688: select decode(primary_cost_method, 2,
4689: (select decode(primary_cost_method, 2, 1, 0)
4690: from mtl_parameters
4691: where organization_id = l_from_org),
4692: 0)
4693: into l_ave_to_ave
4694: from mtl_parameters

Line 4694: from mtl_parameters

4690: from mtl_parameters
4691: where organization_id = l_from_org),
4692: 0)
4693: into l_ave_to_ave
4694: from mtl_parameters
4695: where organization_id = l_to_org;
4696:
4697: IF g_debug = 'Y' THEN
4698: fnd_file.put_line(fnd_file.log, '>>>Transaction action:'||to_char(i_txn_action_id)||' From Org:'||to_char(l_from_org)||' To Org:'||to_char(l_to_org));

Line 4716: from mtl_parameters

4712: l_stmt_num := 15;
4713: IF ( l_std_from_org = 1 OR l_std_to_org = 1 ) THEN
4714: select cost_organization_id
4715: into l_std_cost_org
4716: from mtl_parameters
4717: where organization_id = l_std_org;
4718: END IF;
4719:
4720: if (l_std_org = i_txn_org_id) then

Line 6020: from mtl_parameters

6016: l_ret_val NUMBER;
6017: BEGIN
6018: select decode(primary_cost_method,1,1,0)
6019: into l_ret_val
6020: from mtl_parameters
6021: where organization_id = i_org_id;
6022:
6023: return l_ret_val;
6024: END standard_cost_org;

Line 6406: from mtl_parameters

6402:
6403: /* Added for bugfix 3048258 */
6404: select cost_organization_id
6405: into l_from_cost_org
6406: from mtl_parameters
6407: where organization_id = i_from_org;
6408:
6409: insert into mtl_cst_txn_cost_details (
6410: transaction_id,

Line 6799: mtl_parameters mp,

6795: mp.primary_cost_method "COST_TYPE_ID", /* For use as cost_type_id */
6796: NVL(mp.AVG_RATES_COST_TYPE_ID, -1) "AVG_RATES_COST_TYPE_ID",
6797: decode(msi.INVENTORY_ASSET_FLAG,'Y',0,1) "EXP_ITEM"
6798: FROM mtl_material_transactions mmt,
6799: mtl_parameters mp,
6800: mtl_system_items_b msi
6801: WHERE mmt.organization_id = mp.organization_id
6802: AND mmt.inventory_item_id = msi.inventory_item_id
6803: AND mmt.organization_id = msi.organization_id

Line 8209: mtl_material_transactions mmt, mtl_parameters mpx, mtl_parameters mp

8205: l_parent_org_process_flag,
8206: l_logical_org_id,
8207: l_logical_org_process_flag
8208: FROM
8209: mtl_material_transactions mmt, mtl_parameters mpx, mtl_parameters mp
8210: WHERE
8211: mmt.transaction_id = p_parent_txn_id
8212: AND mpx.organization_id = mmt.transfer_organization_id
8213: AND mp.organization_id = mmt.organization_id

Line 8419: MTL_PARAMETERS

8415: PRIMARY_COST_METHOD
8416: INTO
8417: l_cost_method
8418: FROM
8419: MTL_PARAMETERS
8420: WHERE
8421: organization_id = l_logical_org_id;
8422:
8423:

Line 9364: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,

9360: p_api_version IN NUMBER,
9361: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
9362: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
9363: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
9364: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
9365: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
9366: p_total_primary_qty IN NUMBER,
9367: x_encumbrance_amount OUT NOCOPY NUMBER,
9368: x_encumbrance_account OUT NOCOPY NUMBER,