DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on GMF_LOT_COST_DETAILS

Line 1183: FROM gmf_lot_cost_details

1179: IS
1180: SELECT cost_cmpntcls_id,
1181: cost_analysis_code,
1182: component_cost
1183: FROM gmf_lot_cost_details
1184: WHERE header_id = v_header_id
1185: AND cost_cmpntcls_id = NVL(v_cost_cmpntcls_id,cost_cmpntcls_id)
1186: AND cost_analysis_code = NVL(v_cost_analysis_code,cost_analysis_code);
1187:

Line 1195: FROM gmf_lot_cost_details d,

1191: v_lot_number IN VARCHAR2
1192: )
1193: IS
1194: SELECT sum(component_cost)
1195: FROM gmf_lot_cost_details d,
1196: gmf_lot_costs h
1197: WHERE h.header_id = v_header_id
1198: AND h.header_id = d.header_id
1199: AND h.lot_number = nvl(v_lot_number ,h.lot_number);