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

656: -- if the receiving org is standard and item or sub is expense in the std org,
657: -- do not call calc_layer_average_cost
658: select primary_cost_method
659: into l_to_method
660: from mtl_parameters
661: where organization_id = i_txn_org_id;
662:
663: if (l_to_method = 1) then
664: l_std_org := i_txn_org_id;

Line 1086: from mtl_parameters

1082:
1083: l_stmt_num := 2;
1084: select primary_cost_method
1085: into l_from_method
1086: from mtl_parameters
1087: where organization_id = l_from_org;
1088:
1089: select primary_cost_method
1090: into l_to_method

Line 1091: from mtl_parameters

1087: where organization_id = l_from_org;
1088:
1089: select primary_cost_method
1090: into l_to_method
1091: from mtl_parameters
1092: where organization_id = l_to_org;
1093:
1094: l_stmt_num := 3;
1095: if ((l_from_method NOT IN (5,6)) and (l_to_method NOT IN (5,6))) then

Line 1139: from mtl_parameters

1135: l_stmt_num := 15;
1136: IF ( l_std_from_org = 1 OR l_std_to_org = 1 ) THEN
1137: select cost_organization_id
1138: into l_std_cost_org
1139: from mtl_parameters
1140: where organization_id = l_std_org;
1141: END IF;
1142:
1143: if (l_std_org = i_txn_org_id) then

Line 2450: from mtl_parameters

2446: l_ret_val NUMBER;
2447: BEGIN
2448: select decode(primary_cost_method,1,1,0)
2449: into l_ret_val
2450: from mtl_parameters
2451: where organization_id = i_org_id;
2452:
2453: return l_ret_val;
2454: END standard_cost_org;

Line 2514: from mtl_parameters

2510:
2511: /* Added for bugfix 3048258 */
2512: select cost_organization_id
2513: into l_from_cost_org
2514: from mtl_parameters
2515: where organization_id = i_from_org;
2516:
2517: insert into mtl_cst_txn_cost_details (
2518: transaction_id,

Line 4411: from mtl_parameters

4407:
4408: l_stmt_num := 2;
4409: select primary_cost_method
4410: into l_from_method
4411: from mtl_parameters
4412: where organization_id = l_from_org;
4413:
4414: l_stmt_num := 3;
4415: select primary_cost_method

Line 4417: from mtl_parameters

4413:
4414: l_stmt_num := 3;
4415: select primary_cost_method
4416: into l_to_method
4417: from mtl_parameters
4418: where organization_id = l_to_org;
4419:
4420: --
4421: -- Bug 5702988: This flag was set to 1 in cmllcw.lpc when receiving