APPS.GMO_DISPENSE_PVT dependencies on GMO_MATERIAL_UNDISPENSES

Line 58: FROM GMO_MATERIAL_UNDISPENSES

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)
58: FROM GMO_MATERIAL_UNDISPENSES
59: WHERE dispense_id = p_dispense_id;
60: l_dispense_rec C_GET_DISPENSES%ROWTYPE;
61: BEGIN
62: l_total_dispensed_qty := 0;

Line 124: FROM GMO_MATERIAL_UNDISPENSES

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
123: SELECT nvl(sum(nvl(undispensed_qty,0)+ nvl(material_loss,0)),0)
124: FROM GMO_MATERIAL_UNDISPENSES
125: WHERE dispense_id = p_dispense_id;
126: BEGIN
127: l_mtl_dispensed_quantity := 0;
128: l_mtl_undispensed_quantity := 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 797: FROM GMO_MATERIAL_UNDISPENSES

793: IS
794: l_return_value NUMBER;
795: CURSOR C_GET_LATEST_UNDISPENSE_ID IS
796: SELECT MAX(undispense_id)
797: FROM GMO_MATERIAL_UNDISPENSES
798: WHERE DISPENSE_ID = p_dispense_id;
799: BEGIN
800: l_return_value := null;
801: OPEN C_GET_LATEST_UNDISPENSE_ID;

Line 1000: FROM GMO_MATERIAL_UNDISPENSES

996: FUNCTION GET_NET_REVERSE_DISPENSED_QTY (P_DISPENSE_ID IN NUMBER) RETURN NUMBER
997: IS
998: CURSOR REV_DISP_CUR IS
999: SELECT sum(nvl(undispensed_qty,0))
1000: FROM GMO_MATERIAL_UNDISPENSES
1001: WHERE dispense_id = p_dispense_id;
1002: l_return_value NUMBER;
1003: BEGIN
1004: l_return_value := null;

Line 1015: FROM GMO_MATERIAL_UNDISPENSES

1011: FUNCTION GET_NET_MATERIAL_LOSS (P_DISPENSE_ID IN NUMBER) RETURN NUMBER
1012: IS
1013: CURSOR REV_DISP_CUR IS
1014: SELECT sum(nvl(material_loss,0))
1015: FROM GMO_MATERIAL_UNDISPENSES
1016: WHERE dispense_id = p_dispense_id;
1017: l_return_value NUMBER;
1018: BEGIN
1019: l_return_value := null;

Line 1039: select count(dispense_booth_id) into countValue from gmo_material_undispenses

1035:
1036: if(countValue > 0) then
1037: return 'Yes';
1038: else
1039: select count(dispense_booth_id) into countValue from gmo_material_undispenses
1040: where dispense_booth_id = disp_booth_id;
1041: if(countValue > 0) then
1042: return 'Yes';
1043: end if;

Line 1061: select count(dispense_area_id) into countValue from gmo_material_undispenses

1057:
1058: if(countValue > 0) then
1059: return 'Yes';
1060: else
1061: select count(dispense_area_id) into countValue from gmo_material_undispenses
1062: where dispense_area_id = disp_area_id;
1063: if(countValue > 0) then
1064: return 'Yes';
1065: else