DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_PERIOD_STATUSES

Line 1114: gmf_period_statuses gps

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
1118: AND gps.end_date >= p_date

Line 1149: gmf_period_statuses gps

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
1153: AND gps.end_date >= p_date

Line 1199: ,gmf_period_statuses gps

1195: 0,
1196: cst.nominal_cost,
1197: 0
1198: FROM cm_rsrc_dtl cst
1199: ,gmf_period_statuses gps
1200: ,gme_batch_step_resources gbsr
1201: WHERE gps.legal_entity_id = p_le_id
1202: AND gps.cost_type_id = p_cost_type_id
1203: AND gps.start_date <= p_date

Line 1344: gmf_period_statuses gps

1340: )
1341: IS
1342: SELECT cst.nominal_cost
1343: FROM cm_rsrc_dtl cst,
1344: gmf_period_statuses gps
1345: WHERE gps.legal_entity_id = p_le_id
1346: AND gps.cost_type_id = p_cost_type_id
1347: AND gps.start_date <= p_date
1348: AND gps.end_date >= p_date