APPS.GMO_DISPENSE_PVT dependencies on GMO_MATERIAL_DISPENSES

Line 53: FROM GMO_MATERIAL_DISPENSES

49: l_undispensed_qty NUMBER;
50: l_dispensed_qty NUMBER;
51: CURSOR C_GET_DISPENSES IS
52: SELECT inventory_item_id,lot_number, dispensed_qty, dispense_uom, organization_id, dispense_id
53: FROM GMO_MATERIAL_DISPENSES
54: WHERE MATERIAL_STATUS = 'DISPENSD'
55: AND RESERVATION_ID = P_RESERVATION_ID;
56: CURSOR C_GET_UNDISPENSED_QTY(p_dispense_id NUMBER) IS
57: SELECT nvl(sum(nvl(undispensed_qty,0)+ nvl(material_loss,0)),0)

Line 118: FROM GMO_MATERIAL_DISPENSES

114: l_undispensed_qty NUMBER;
115: l_dispensed_qty NUMBER;
116: CURSOR C_GET_DISPENSES IS
117: SELECT inventory_item_id,lot_number, dispensed_qty, dispense_uom, organization_id, dispense_id
118: FROM GMO_MATERIAL_DISPENSES
119: WHERE MATERIAL_STATUS = 'DISPENSD'
120: AND MATERIAL_DETAIL_ID = P_MATERIAL_DETAIL_ID;
121: l_dispense_rec C_GET_DISPENSES%ROWTYPE;
122: CURSOR C_GET_UNDISPENSED_QTY(p_dispense_id NUMBER) IS

Line 180: from gmo_material_dispenses

176: l_dispensed_qty NUMBER;
177: l_undispensed_qty NUMBER;
178: CURSOR C_GET_DISPENSED_QTY IS
179: select dispensed_qty l_dispensed_qty
180: from gmo_material_dispenses
181: where dispense_id = p_dispense_id
182: and material_status = 'DISPENSD';
183: CURSOR C_GET_UNDISPENSED_QTY IS
184: SELECT nvl(sum(nvl(undispensed_qty,0)+ nvl(material_loss,0)),0)

Line 185: from gmo_material_undispenses u , gmo_material_dispenses d

181: where dispense_id = p_dispense_id
182: and material_status = 'DISPENSD';
183: CURSOR C_GET_UNDISPENSED_QTY IS
184: SELECT nvl(sum(nvl(undispensed_qty,0)+ nvl(material_loss,0)),0)
185: from gmo_material_undispenses u , gmo_material_dispenses d
186: where d.dispense_id = p_dispense_id
187: and d.dispense_id = u.dispense_id(+)
188: and d.material_status = 'DISPENSD';
189: BEGIN

Line 417: FROM GMO_MATERIAL_DISPENSES GMO

413: l_dispense_config_rec GMO_DISPENSE_CONFIG%ROWTYPE;
414: l_net_dispensed_quantity NUMBER;
415: CURSOR C_GET_DISP_DETAILS IS
416: SELECT GMO.MATERIAL_DETAIL_ID, GMO.INVENTORY_ITEM_ID, GMO.ORGANIZATION_ID
417: FROM GMO_MATERIAL_DISPENSES GMO
418: WHERE GMO.DISPENSE_ID = P_DISPENSE_ID;
419: l_GET_DISP_DETAILS_REC C_GET_DISP_DETAILS%ROWTYPE;
420: BEGIN
421: X_INSTRUCTION_ENTITY_DEF_KEY := null;

Line 488: from gmo_material_dispenses

484: SELECT Dispense_id,
485: dispensed_qty,
486: dispense_uom,
487: GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) net_dispensed_qty
488: from gmo_material_dispenses
489: WHERE reservation_id = p_reservation_id
490: and material_status = 'DISPENSD'
491: and GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) > 0;
492: l_reservation_record mtl_reservations%ROWTYPE;

Line 781: FROM GMO_MATERIAL_DISPENSES

777: l_return_value NUMBER;
778: -- change for kiosk : start
779: CURSOR C_GET_MAX_DISPENSE_ID IS
780: SELECT MAX(dispense_id)
781: FROM GMO_MATERIAL_DISPENSES
782: WHERE BATCH_ID = p_batch_id;
783: -- change for kiosk : End
784: BEGIN
785: l_return_value := null;

Line 1033: select count(dispense_booth_id) into countValue from gmo_material_dispenses

1029: countValue number default 0;
1030:
1031: begin
1032:
1033: select count(dispense_booth_id) into countValue from gmo_material_dispenses
1034: where dispense_booth_id = disp_booth_id;
1035:
1036: if(countValue > 0) then
1037: return 'Yes';

Line 1055: select count(dispense_area_id) into countValue from gmo_material_dispenses

1051: countValue number default 0;
1052:
1053: begin
1054:
1055: select count(dispense_area_id) into countValue from gmo_material_dispenses
1056: where dispense_area_id = disp_area_id;
1057:
1058: if(countValue > 0) then
1059: return 'Yes';