DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on GMF_LOT_COSTS

Line 1368: gmf_lot_costs h

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);
1372:

Line 1394: FROM gmf_lot_costs

1390: v_organization_id IN VARCHAR2
1391: )
1392: IS
1393: SELECT MAX(header_id)
1394: FROM gmf_lot_costs
1395: WHERE inventory_item_id = p_inventory_item_id
1396: AND cost_type_id = v_cost_type_id
1397: AND lot_number = v_lot_number
1398: AND cost_date <= v_trans_date

Line 1418: FROM gmf_lot_costs

1414: PARTITION BY lot_number
1415: ORDER BY cost_date desc,
1416: header_id desc
1417: ) as rank
1418: FROM gmf_lot_costs
1419: WHERE cost_date <= v_trans_date
1420: AND inventory_item_id = v_item_id
1421: AND organization_id = v_organization_id
1422: AND cost_type_id = v_cost_type_id