APPS.INV_COST_GROUP_UPDATE dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 263: FROM mtl_onhand_quantities_detail moq

259: IF p_serial_number IS NULL THEN
260: SELECT 1 INTO l_onhand FROM dual
261: WHERE exists
262: (SELECT organization_id
263: FROM mtl_onhand_quantities_detail moq
264: WHERE (moq.lot_number = p_lot_number
265: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
266: AND (moq.revision = p_revision
267: OR (p_revision IS NULL AND moq.revision IS NULL))

Line 828: FROM mtl_onhand_quantities_detail moq

824: IF p_lpn_id IS NULL THEN
825: IF p_serial_number IS NULL THEN
826: SELECT moq.cost_group_id -- Loose material, no serial control
827: INTO x_cost_group_id
828: FROM mtl_onhand_quantities_detail moq
829: WHERE (moq.lot_number = p_lot_number
830: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
831: AND (moq.revision = p_revision
832: OR (p_revision IS NULL AND moq.revision IS NULL))

Line 880: FROM mtl_onhand_quantities_detail moq

876: AND wlpn.lpn_id = p_lpn_id
877: AND ROWNUM = 1
878: UNION --Bug#6133411.Added the UNION and outer SELECT as well.
879: SELECT moq.cost_group_id
880: FROM mtl_onhand_quantities_detail moq
881: WHERE (moq.lot_number = p_lot_number
882: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
883: AND (moq.revision = p_revision
884: OR (p_revision IS NULL AND moq.revision IS NULL))