APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_ACTUAL_COST_SUBELEMENT

Line 2096: FROM mtl_actual_cost_subelement macs,

2092: 'P' transaction_status_code,
2093: br.resource_id resource_id,
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

Line 2139: FROM mtl_actual_cost_subelement macs,

2135: 'P' transaction_status_code,
2136: br.resource_id resource_id,
2137: macs.cost_element_id cost_element_id,
2138: l_xfer_currency_code denom_currency_code
2139: FROM mtl_actual_cost_subelement macs,
2140: bom_resources br
2141: WHERE macs.transaction_id = p_transfer_transaction_id
2142: AND macs.ORGANIZATION_ID = br.ORGANIZATION_ID
2143: AND macs.cost_element_id = 2

Line 2204: from mtl_actual_cost_subelement macs

2200: organization_id,
2201: cost_element_id,
2202: level_type,
2203: layer_id
2204: from mtl_actual_cost_subelement macs
2205: where transaction_id = p_transaction_id
2206: and organization_id = p_organization_id
2207: group by transaction_id,
2208: organization_id,

Line 2284: from mtl_actual_cost_subelement macs

2280: organization_id,
2281: cost_element_id,
2282: level_type,
2283: layer_id
2284: from mtl_actual_cost_subelement macs
2285: where transaction_id = p_transaction_id
2286: and organization_id = p_organization_id
2287: group by transaction_id,
2288: organization_id,

Line 2303: FROM mtl_actual_cost_subelement macs

2299: AND msi.costing_enabled_flag = 'N'
2300: AND mcacd.actual_cost <> 0
2301: /* AND NOT EXISTS (
2302: SELECT null
2303: FROM mtl_actual_cost_subelement macs
2304: WHERE macs.transaction_id =
2305: mcacd.transaction_id
2306: AND macs.organization_id =
2307: mcacd.organization_id

Line 2387: mtl_actual_cost_subelement macs

2383: 3, l_xfer_currency_code,
2384: p_denom_currency_code) denom_currency_code
2385: FROM mtl_cst_actual_cost_details mcacd,
2386: cst_cost_elem_exp_types cceet,
2387: mtl_actual_cost_subelement macs
2388: WHERE mcacd.transaction_id = decode(p_transaction_action_id,
2389: 3, p_transfer_transaction_id ,
2390: p_transaction_id)
2391: AND mcacd.organization_id = decode(p_transaction_action_id,

Line 2469: FROM mtl_actual_cost_subelement macs

2465: AND mcacd.layer_id = decode(p_primary_cost_method,
2466: 1, -1, ccicv.layer_id) --PJMSTD
2467: AND NOT EXISTS (
2468: SELECT null
2469: FROM mtl_actual_cost_subelement macs
2470: WHERE macs.transaction_id =
2471: mcacd.transaction_id
2472: AND macs.organization_id =
2473: mcacd.organization_id

Line 2964: FROM mtl_actual_cost_subelement macs

2960:
2961: /* Bug #1944099. Only this level MOH costs are collected. */
2962: SELECT NVL(MAX(macs.transaction_id),-99)
2963: INTO l_earn_moh
2964: FROM mtl_actual_cost_subelement macs
2965: WHERE macs.transaction_id = p_transaction_id
2966: AND macs.organization_id = p_organization_id
2967: AND macs.actual_cost <> 0
2968: AND macs.level_type = 1

Line 2979: from mtl_actual_cost_subelement macs

2975:
2976: If (p_transaction_action_id = 3 AND p_to_project_id is not NULL) then
2977: select NVL(MAX(macs.transaction_id),-99)
2978: into l_earn_tomoh
2979: from mtl_actual_cost_subelement macs
2980: WHERE macs.transaction_id = p_transfer_transaction_id
2981: AND macs.organization_id = p_transfer_organization_id
2982: AND macs.actual_cost <> 0
2983: AND macs.level_type = 1

Line 5296: FROM mtl_actual_cost_subelement macs,

5292:
5293: BEGIN
5294: SELECT 'NO VALUE'
5295: INTO l_exp_type
5296: FROM mtl_actual_cost_subelement macs,
5297: bom_resources br
5298: WHERE macs.transaction_id = p_transaction_id
5299: AND macs.organization_id = p_organization_id
5300: AND macs.cost_element_id = 2