DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on CST_COST_ELEM_EXP_TYPES

Line 2386: cst_cost_elem_exp_types cceet,

2382: decode(p_transaction_action_id,
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)

Line 2535: cst_cost_elem_exp_types cceet,

2531: 'P' transaction_status_code ,
2532: mcacd.cost_element_id cost_element_id,
2533: p_denom_currency_code denom_currency_code
2534: FROM mtl_cst_actual_cost_details mcacd,
2535: cst_cost_elem_exp_types cceet,
2536: cst_cg_item_costs_view ccicv
2537: WHERE mcacd.transaction_id = p_transaction_id
2538: AND mcacd.organization_id = p_organization_id
2539: AND mcacd.inventory_item_id = p_inventory_item_id

Line 3063: FROM cst_cost_elem_exp_types cceet

3059: DECODE(sign(p_primary_quantity),1,
3060: cceet.EXPENDITURE_TYPE_OUT,
3061: cceet.EXPENDITURE_TYPE_IN)
3062: INTO l_exp_type
3063: FROM cst_cost_elem_exp_types cceet
3064: WHERE cceet.cost_element_id = c_rec1.cost_element_id;
3065:
3066: END IF;
3067:

Line 3720: FROM cst_cost_elem_exp_types cceet

3716: decode(sign(p_primary_quantity),1,
3717: cceet.EXPENDITURE_TYPE_IN,
3718: cceet.EXPENDITURE_TYPE_OUT))
3719: INTO l_exp_type
3720: FROM cst_cost_elem_exp_types cceet
3721: WHERE cceet.cost_element_id = c_rec3.cost_element_id;
3722: END IF; -- action_id = 7
3723:
3724: END IF;

Line 4212: FROM cst_cost_elem_exp_types cceet

4208: decode(sign(p_primary_quantity),1,
4209: cceet.EXPENDITURE_TYPE_OUT,
4210: cceet.EXPENDITURE_TYPE_IN)
4211: INTO l_exp_type
4212: FROM cst_cost_elem_exp_types cceet
4213: WHERE cceet.cost_element_id = c_rec5.cost_element_id;
4214:
4215: END IF;
4216:

Line 4457: FROM cst_cost_elem_exp_types cceet

4453: decode(sign(-1 * p_primary_quantity),1,
4454: cceet.EXPENDITURE_TYPE_OUT,
4455: cceet.EXPENDITURE_TYPE_IN)
4456: INTO l_exp_type
4457: FROM cst_cost_elem_exp_types cceet
4458: WHERE cceet.cost_element_id = c_rec6.cost_element_id;
4459:
4460: pm_insert_pti_pvt
4461: (p_transaction_source =>