APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_ACTUAL_COST_SUBELEMENT

Line 2035: FROM mtl_actual_cost_subelement macs,

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

Line 2078: FROM mtl_actual_cost_subelement macs,

2074: 'P' transaction_status_code,
2075: br.resource_id resource_id,
2076: macs.cost_element_id cost_element_id,
2077: l_xfer_currency_code denom_currency_code
2078: FROM mtl_actual_cost_subelement macs,
2079: bom_resources br
2080: WHERE macs.transaction_id = p_transfer_transaction_id
2081: AND macs.ORGANIZATION_ID = br.ORGANIZATION_ID
2082: AND macs.cost_element_id = 2

Line 2143: from mtl_actual_cost_subelement macs

2139: organization_id,
2140: cost_element_id,
2141: level_type,
2142: layer_id
2143: from mtl_actual_cost_subelement macs
2144: where transaction_id = p_transaction_id
2145: and organization_id = p_organization_id
2146: group by transaction_id,
2147: organization_id,

Line 2223: from mtl_actual_cost_subelement macs

2219: organization_id,
2220: cost_element_id,
2221: level_type,
2222: layer_id
2223: from mtl_actual_cost_subelement macs
2224: where transaction_id = p_transaction_id
2225: and organization_id = p_organization_id
2226: group by transaction_id,
2227: organization_id,

Line 2242: FROM mtl_actual_cost_subelement macs

2238: AND msi.costing_enabled_flag = 'N'
2239: AND mcacd.actual_cost <> 0
2240: /* AND NOT EXISTS (
2241: SELECT null
2242: FROM mtl_actual_cost_subelement macs
2243: WHERE macs.transaction_id =
2244: mcacd.transaction_id
2245: AND macs.organization_id =
2246: mcacd.organization_id

Line 2326: mtl_actual_cost_subelement macs

2322: 3, l_xfer_currency_code,
2323: p_denom_currency_code) denom_currency_code
2324: FROM mtl_cst_actual_cost_details mcacd,
2325: cst_cost_elem_exp_types cceet,
2326: mtl_actual_cost_subelement macs
2327: WHERE mcacd.transaction_id = decode(p_transaction_action_id,
2328: 3, p_transfer_transaction_id ,
2329: p_transaction_id)
2330: AND mcacd.organization_id = decode(p_transaction_action_id,

Line 2408: FROM mtl_actual_cost_subelement macs

2404: AND mcacd.layer_id = decode(p_primary_cost_method,
2405: 1, -1, ccicv.layer_id) --PJMSTD
2406: AND NOT EXISTS (
2407: SELECT null
2408: FROM mtl_actual_cost_subelement macs
2409: WHERE macs.transaction_id =
2410: mcacd.transaction_id
2411: AND macs.organization_id =
2412: mcacd.organization_id

Line 2903: FROM mtl_actual_cost_subelement macs

2899:
2900: /* Bug #1944099. Only this level MOH costs are collected. */
2901: SELECT NVL(MAX(macs.transaction_id),-99)
2902: INTO l_earn_moh
2903: FROM mtl_actual_cost_subelement macs
2904: WHERE macs.transaction_id = p_transaction_id
2905: AND macs.organization_id = p_organization_id
2906: AND macs.actual_cost <> 0
2907: AND macs.level_type = 1

Line 2918: from mtl_actual_cost_subelement macs

2914:
2915: If (p_transaction_action_id = 3 AND p_to_project_id is not NULL) then
2916: select NVL(MAX(macs.transaction_id),-99)
2917: into l_earn_tomoh
2918: from mtl_actual_cost_subelement macs
2919: WHERE macs.transaction_id = p_transfer_transaction_id
2920: AND macs.organization_id = p_transfer_organization_id
2921: AND macs.actual_cost <> 0
2922: AND macs.level_type = 1

Line 5235: FROM mtl_actual_cost_subelement macs,

5231:
5232: BEGIN
5233: SELECT 'NO VALUE'
5234: INTO l_exp_type
5235: FROM mtl_actual_cost_subelement macs,
5236: bom_resources br
5237: WHERE macs.transaction_id = p_transaction_id
5238: AND macs.organization_id = p_organization_id
5239: AND macs.cost_element_id = 2