APPS.CSTPOYUT dependencies on CST_ITEM_COSTS

Line 85: FROM cst_item_costs cic, mtl_parameters mp

81: NVL(cic.resource_cost,0) +
82: NVL(cic.outside_processing_cost,0) +
83: NVL(cic.overhead_cost,0)) * -1 * i_txn_qty) ,
84: 1
85: FROM cst_item_costs cic, mtl_parameters mp
86: WHERE cic.inventory_item_id = i_item_id
87: AND cic.organization_id = mp.cost_organization_id
88: AND mp.organization_id = i_org_id
89: AND cic.cost_type_id = i_cost_type_id

Line 96: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP

92: AND woy.organization_id = i_org_id
93: AND woy.operation_seq_num = i_op_seq_num
94: AND EXISTS
95: (SELECT 'Check if the item has cost'
96: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP
97: WHERE CIC.INVENTORY_ITEM_ID = i_item_id
98: AND CIC.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
99: AND MP.ORGANIZATION_ID = i_org_id
100: AND CIC.COST_TYPE_ID = i_cost_type_id);