APPS.CSTPLVCP dependencies on MTL_PARAMETERS

Line 95: FROM mtl_parameters mp, mtl_material_transactions mmt

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

Line 594: from mtl_parameters

590: -- if the receiving org is standard and item or sub is expense in the std org,
591: -- do not call calc_layer_average_cost
592: select primary_cost_method
593: into l_to_method
594: from mtl_parameters
595: where organization_id = i_txn_org_id;
596:
597: if (l_to_method = 1) then
598: l_std_org := i_txn_org_id;

Line 1020: from mtl_parameters

1016:
1017: l_stmt_num := 2;
1018: select primary_cost_method
1019: into l_from_method
1020: from mtl_parameters
1021: where organization_id = l_from_org;
1022:
1023: select primary_cost_method
1024: into l_to_method

Line 1025: from mtl_parameters

1021: where organization_id = l_from_org;
1022:
1023: select primary_cost_method
1024: into l_to_method
1025: from mtl_parameters
1026: where organization_id = l_to_org;
1027:
1028: l_stmt_num := 3;
1029: if ((l_from_method NOT IN (5,6)) and (l_to_method NOT IN (5,6))) then

Line 1073: from mtl_parameters

1069: l_stmt_num := 15;
1070: IF ( l_std_from_org = 1 OR l_std_to_org = 1 ) THEN
1071: select cost_organization_id
1072: into l_std_cost_org
1073: from mtl_parameters
1074: where organization_id = l_std_org;
1075: END IF;
1076:
1077: if (l_std_org = i_txn_org_id) then

Line 2384: from mtl_parameters

2380: l_ret_val NUMBER;
2381: BEGIN
2382: select decode(primary_cost_method,1,1,0)
2383: into l_ret_val
2384: from mtl_parameters
2385: where organization_id = i_org_id;
2386:
2387: return l_ret_val;
2388: END standard_cost_org;

Line 2448: from mtl_parameters

2444:
2445: /* Added for bugfix 3048258 */
2446: select cost_organization_id
2447: into l_from_cost_org
2448: from mtl_parameters
2449: where organization_id = i_from_org;
2450:
2451: insert into mtl_cst_txn_cost_details (
2452: transaction_id,

Line 4344: from mtl_parameters

4340:
4341: l_stmt_num := 2;
4342: select primary_cost_method
4343: into l_from_method
4344: from mtl_parameters
4345: where organization_id = l_from_org;
4346:
4347: l_stmt_num := 3;
4348: select primary_cost_method

Line 4350: from mtl_parameters

4346:
4347: l_stmt_num := 3;
4348: select primary_cost_method
4349: into l_to_method
4350: from mtl_parameters
4351: where organization_id = l_to_org;
4352:
4353: --
4354: -- Bug 5702988: This flag was set to 1 in cmllcw.lpc when receiving