DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on CM_CMPT_DTL

Line 1113: FROM cm_cmpt_dtl cst,

1109: , p_date DATE
1110: )
1111: IS
1112: SELECT sum(cst.cmpnt_cost)
1113: FROM cm_cmpt_dtl cst,
1114: gmf_period_statuses gps
1115: WHERE gps.legal_entity_id = p_le_id
1116: AND gps.cost_type_id = p_cost_type_id
1117: AND gps.start_date <= p_date

Line 1148: FROM cm_cmpt_dtl cst,

1144: cst.cost_level,
1145: cst.cmpnt_cost,
1146: 0
1147: )
1148: FROM cm_cmpt_dtl cst,
1149: gmf_period_statuses gps
1150: WHERE gps.legal_entity_id = p_le_id
1151: AND gps.cost_type_id = p_cost_type_id
1152: AND gps.start_date <= p_date

Line 5203: -- use the standard (period-based) cost from cm_cmpt_dtl,

5199: -- The transactions are sorted by date and then by line type. This should
5200: -- give the correct ordering of transactions for the rollup.
5201:
5202: -- If item is not lot controlled or is not lot costed
5203: -- use the standard (period-based) cost from cm_cmpt_dtl,
5204: -- otherwise use the lot cost
5205:
5206: IF l_step_tab(i).materials(j).line_type IN (-1,2) -- Treat byproducts as negative ingredients
5207: OR l_step_tab(i).materials(j).line_type = 1 AND l_step_tab(i).materials(j).lot_costed_flag = 0