[Home] [Help]
315: l_stmt_num := 10;
316:
317: SELECT mp.primary_cost_method
318: INTO l_primary_cost_method
319: FROM mtl_parameters mp
320: WHERE mp.organization_id = p_org_id;
321:
322: l_stmt_num := 15;
323:
2094: macs.cost_element_id cost_element_id,
2095: p_denom_currency_code denom_currency_code
2096: FROM mtl_actual_cost_subelement macs,
2097: bom_resources br,
2098: mtl_parameters mp
2099: WHERE macs.transaction_id = p_transaction_id
2100: AND macs.ORGANIZATION_ID = mp.ORGANIZATION_ID
2101: AND mp.cost_organization_id = br.organization_id
2102: AND macs.cost_element_id = 2
2681: -- bug 3150050 staging Txfrs
2682: IF (p_transaction_action_id IN (2,3,12,28) ) THEN
2683: SELECT primary_cost_method, decode(pm_cost_collection_enabled, 1, 1, 0)
2684: INTO l_primary_cost_method_snd, l_cost_collection_enabled_snd
2685: FROM mtl_parameters
2686: WHERE organization_id = p_transfer_organization_id ;
2687: END IF;
2688:
2689: -- Initialize the batch name as CC followed by group_id
5244: decode(br1.expenditure_type,NULL,'NO VALUE',
5245: br1.expenditure_type),
5246: br.expenditure_type)
5247: INTO l_exp_type
5248: FROM mtl_parameters mp,
5249: cst_item_cost_details cicd,
5250: bom_resources br,
5251: bom_resources br1
5252: WHERE mp.organization_id = p_organization_id
6721: l_stmt_num := 35;
6722: /* Bug #2128760. CITW only applies to average costing orgs */
6723: SELECT primary_cost_method
6724: INTO l_cost_method
6725: FROM mtl_parameters
6726: WHERE organization_id = l_organization_id;
6727:
6728: l_stmt_num := 40;
6729: /* Check for standard to standard direct interorg transfers. In this case
6730: the accounting entries are all made against the sending transaction_id. */
6731: IF (l_xfer_organization_id IS NOT NULL) THEN
6732: SELECT primary_cost_method
6733: INTO l_xfer_cost_method
6734: FROM mtl_parameters
6735: WHERE organization_id = l_xfer_organization_id;
6736: END IF;
6737:
6738: l_stmt_num := 45;