DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on GMF_LOT_COST_DETAILS

Line 1355: FROM gmf_lot_cost_details

1351: IS
1352: SELECT cost_cmpntcls_id,
1353: cost_analysis_code,
1354: component_cost
1355: FROM gmf_lot_cost_details
1356: WHERE header_id = v_header_id
1357: AND cost_cmpntcls_id = NVL(v_cost_cmpntcls_id,cost_cmpntcls_id)
1358: AND cost_analysis_code = NVL(v_cost_analysis_code,cost_analysis_code);
1359:

Line 1367: FROM gmf_lot_cost_details d,

1363: v_lot_number IN VARCHAR2
1364: )
1365: IS
1366: SELECT sum(component_cost)
1367: FROM gmf_lot_cost_details d,
1368: gmf_lot_costs h
1369: WHERE h.header_id = v_header_id
1370: AND h.header_id = d.header_id
1371: AND h.lot_number = nvl(v_lot_number ,h.lot_number);