DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on CST_COST_ELEM_EXP_TYPES

Line 2325: cst_cost_elem_exp_types cceet,

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

Line 2474: cst_cost_elem_exp_types cceet,

2470: 'P' transaction_status_code ,
2471: mcacd.cost_element_id cost_element_id,
2472: p_denom_currency_code denom_currency_code
2473: FROM mtl_cst_actual_cost_details mcacd,
2474: cst_cost_elem_exp_types cceet,
2475: cst_cg_item_costs_view ccicv
2476: WHERE mcacd.transaction_id = p_transaction_id
2477: AND mcacd.organization_id = p_organization_id
2478: AND mcacd.inventory_item_id = p_inventory_item_id

Line 3002: FROM cst_cost_elem_exp_types cceet

2998: DECODE(sign(p_primary_quantity),1,
2999: cceet.EXPENDITURE_TYPE_OUT,
3000: cceet.EXPENDITURE_TYPE_IN)
3001: INTO l_exp_type
3002: FROM cst_cost_elem_exp_types cceet
3003: WHERE cceet.cost_element_id = c_rec1.cost_element_id;
3004:
3005: END IF;
3006:

Line 3659: FROM cst_cost_elem_exp_types cceet

3655: decode(sign(p_primary_quantity),1,
3656: cceet.EXPENDITURE_TYPE_IN,
3657: cceet.EXPENDITURE_TYPE_OUT))
3658: INTO l_exp_type
3659: FROM cst_cost_elem_exp_types cceet
3660: WHERE cceet.cost_element_id = c_rec3.cost_element_id;
3661: END IF; -- action_id = 7
3662:
3663: END IF;

Line 4151: FROM cst_cost_elem_exp_types cceet

4147: decode(sign(p_primary_quantity),1,
4148: cceet.EXPENDITURE_TYPE_OUT,
4149: cceet.EXPENDITURE_TYPE_IN)
4150: INTO l_exp_type
4151: FROM cst_cost_elem_exp_types cceet
4152: WHERE cceet.cost_element_id = c_rec5.cost_element_id;
4153:
4154: END IF;
4155:

Line 4396: FROM cst_cost_elem_exp_types cceet

4392: decode(sign(-1 * p_primary_quantity),1,
4393: cceet.EXPENDITURE_TYPE_OUT,
4394: cceet.EXPENDITURE_TYPE_IN)
4395: INTO l_exp_type
4396: FROM cst_cost_elem_exp_types cceet
4397: WHERE cceet.cost_element_id = c_rec6.cost_element_id;
4398:
4399: pm_insert_pti_pvt
4400: (p_transaction_source =>