[Home] [Help]
314: l_stmt_num := 10;
315:
316: SELECT mp.primary_cost_method
317: INTO l_primary_cost_method
318: FROM mtl_parameters mp
319: WHERE mp.organization_id = p_org_id;
320:
321: l_stmt_num := 15;
322:
2033: macs.cost_element_id cost_element_id,
2034: p_denom_currency_code denom_currency_code
2035: FROM mtl_actual_cost_subelement macs,
2036: bom_resources br,
2037: mtl_parameters mp
2038: WHERE macs.transaction_id = p_transaction_id
2039: AND macs.ORGANIZATION_ID = mp.ORGANIZATION_ID
2040: AND mp.cost_organization_id = br.organization_id
2041: AND macs.cost_element_id = 2
2620: -- bug 3150050 staging Txfrs
2621: IF (p_transaction_action_id IN (2,3,12,28) ) THEN
2622: SELECT primary_cost_method, decode(pm_cost_collection_enabled, 1, 1, 0)
2623: INTO l_primary_cost_method_snd, l_cost_collection_enabled_snd
2624: FROM mtl_parameters
2625: WHERE organization_id = p_transfer_organization_id ;
2626: END IF;
2627:
2628: -- Initialize the batch name as CC followed by group_id
5183: decode(br1.expenditure_type,NULL,'NO VALUE',
5184: br1.expenditure_type),
5185: br.expenditure_type)
5186: INTO l_exp_type
5187: FROM mtl_parameters mp,
5188: cst_item_cost_details cicd,
5189: bom_resources br,
5190: bom_resources br1
5191: WHERE mp.organization_id = p_organization_id
6584: l_stmt_num := 35;
6585: /* Bug #2128760. CITW only applies to average costing orgs */
6586: SELECT primary_cost_method
6587: INTO l_cost_method
6588: FROM mtl_parameters
6589: WHERE organization_id = l_organization_id;
6590:
6591: l_stmt_num := 40;
6592: /* Check for standard to standard direct interorg transfers. In this case
6593: the accounting entries are all made against the sending transaction_id. */
6594: IF (l_xfer_organization_id IS NOT NULL) THEN
6595: SELECT primary_cost_method
6596: INTO l_xfer_cost_method
6597: FROM mtl_parameters
6598: WHERE organization_id = l_xfer_organization_id;
6599: END IF;
6600:
6601: l_stmt_num := 45;