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

2779: /* Get the Default MOH sub element of the organization*/
2780:
2781: select DEFAULT_MATL_OVHD_COST_ID
2782: into l_default_MOH_subelement
2783: from mtl_parameters
2784: where organization_id= I_ORG_ID;
2785:
2786: IF g_debug = 'Y' THEN
2787: fnd_file.put_line(fnd_file.log, 'Apply_Material_Overhead <<<');

Line 4011: mtl_parameters mp

4007: UPDATE mtl_material_transactions mmt
4008: SET prior_costed_quantity = (
4009: SELECT cql.layer_quantity - mmt.primary_quantity
4010: FROM cst_quantity_layers cql,
4011: mtl_parameters mp
4012: WHERE cql.organization_id = i_org_id
4013: AND cql.inventory_item_id = l_item_id
4014: AND cql.cost_group_id = mp.default_cost_group_id
4015: AND mp.organization_id = i_org_id

Line 4021: mtl_parameters mp

4017: WHERE mmt.transaction_id = i_txn_id
4018: AND EXISTS (
4019: SELECT 'X'
4020: FROM cst_quantity_layers cql,
4021: mtl_parameters mp
4022: WHERE cql.organization_id = i_org_id
4023: AND cql.inventory_item_id = l_item_id
4024: AND cql.cost_group_id = mp.default_cost_group_id
4025: AND mp.organization_id = i_org_id

Line 4170: from mtl_parameters

4166: /* Get the Default MOH sub element of the organization*/
4167:
4168: select DEFAULT_MATL_OVHD_COST_ID
4169: into l_default_MOH_subelement
4170: from mtl_parameters
4171: where organization_id= I_ORG_ID;
4172:
4173: IF g_debug = 'Y' THEN
4174: fnd_file.put_line(fnd_file.log, '>>>>Inside Update_Item_Cost');

Line 4515: from mtl_parameters

4511:
4512: l_stmt_num := 7;
4513: select decode(primary_cost_method, 2,
4514: (select decode(primary_cost_method, 2, 1, 0)
4515: from mtl_parameters
4516: where organization_id = l_from_org),
4517: 0)
4518: into l_ave_to_ave
4519: from mtl_parameters

Line 4519: from mtl_parameters

4515: from mtl_parameters
4516: where organization_id = l_from_org),
4517: 0)
4518: into l_ave_to_ave
4519: from mtl_parameters
4520: where organization_id = l_to_org;
4521:
4522: IF g_debug = 'Y' THEN
4523: 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 4541: from mtl_parameters

4537: l_stmt_num := 15;
4538: IF ( l_std_from_org = 1 OR l_std_to_org = 1 ) THEN
4539: select cost_organization_id
4540: into l_std_cost_org
4541: from mtl_parameters
4542: where organization_id = l_std_org;
4543: END IF;
4544:
4545: if (l_std_org = i_txn_org_id) then

Line 5827: from mtl_parameters

5823: l_ret_val NUMBER;
5824: BEGIN
5825: select decode(primary_cost_method,1,1,0)
5826: into l_ret_val
5827: from mtl_parameters
5828: where organization_id = i_org_id;
5829:
5830: return l_ret_val;
5831: END standard_cost_org;

Line 6213: from mtl_parameters

6209:
6210: /* Added for bugfix 3048258 */
6211: select cost_organization_id
6212: into l_from_cost_org
6213: from mtl_parameters
6214: where organization_id = i_from_org;
6215:
6216: insert into mtl_cst_txn_cost_details (
6217: transaction_id,

Line 6606: mtl_parameters mp,

6602: mp.primary_cost_method "COST_TYPE_ID", /* For use as cost_type_id */
6603: NVL(mp.AVG_RATES_COST_TYPE_ID, -1) "AVG_RATES_COST_TYPE_ID",
6604: decode(msi.INVENTORY_ASSET_FLAG,'Y',0,1) "EXP_ITEM"
6605: FROM mtl_material_transactions mmt,
6606: mtl_parameters mp,
6607: mtl_system_items_b msi
6608: WHERE mmt.organization_id = mp.organization_id
6609: AND mmt.inventory_item_id = msi.inventory_item_id
6610: AND mmt.organization_id = msi.organization_id

Line 8014: mtl_material_transactions mmt, mtl_parameters mpx, mtl_parameters mp

8010: l_parent_org_process_flag,
8011: l_logical_org_id,
8012: l_logical_org_process_flag
8013: FROM
8014: mtl_material_transactions mmt, mtl_parameters mpx, mtl_parameters mp
8015: WHERE
8016: mmt.transaction_id = p_parent_txn_id
8017: AND mpx.organization_id = mmt.transfer_organization_id
8018: AND mp.organization_id = mmt.organization_id

Line 8222: MTL_PARAMETERS

8218: PRIMARY_COST_METHOD
8219: INTO
8220: l_cost_method
8221: FROM
8222: MTL_PARAMETERS
8223: WHERE
8224: organization_id = l_logical_org_id;
8225:
8226:

Line 9167: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,

9163: p_api_version IN NUMBER,
9164: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
9165: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
9166: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
9167: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
9168: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
9169: p_total_primary_qty IN NUMBER,
9170: x_encumbrance_amount OUT NOCOPY NUMBER,
9171: x_encumbrance_account OUT NOCOPY NUMBER,