DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on GME_MATERIAL_DETAILS

Line 1225: FROM gme_material_details d

1221: SELECT
1222: SUM ( NVL((NVL(d.wip_plan_qty, d.plan_qty) - d.actual_qty), 0) *
1223: (original_primary_qty/original_qty))
1224: INTO l_qty
1225: FROM gme_material_details d
1226: , gme_batch_header h
1227: WHERE h.batch_type IN (0,10)
1228: AND h.batch_status IN (1,2)
1229: AND h.batch_id = d.batch_id

Line 2020: FROM gme_material_details d

2016: , d.dtl_um
2017: , NVL(NVL(d.wip_plan_qty, d.plan_qty) - d.actual_qty, 0))-
2018: NVL(mtr.primary_reservation_quantity,0))
2019: INTO qty
2020: FROM gme_material_details d
2021: , gme_batch_header h
2022: , mtl_reservations mtr
2023: WHERE h.batch_type IN (0,10)
2024: AND h.batch_status IN (1,2)