APPS.WSH_DELIVERY_VALIDATIONS dependencies on STANDARD

Line 232: AND item_type_code NOT IN ('STANDARD','OPTION');

228: SELECT ato_line_id
229: FROM oe_order_lines_all
230: WHERE top_model_line_id = top_model_line
231: AND ato_line_id = line_id
232: AND item_type_code NOT IN ('STANDARD','OPTION');
233:
234: l_detail_id NUMBER;
235: l_item_id NUMBER;
236: qty NUMBER;

Line 1324: IF l_delivery_type = 'STANDARD' THEN

1320: END IF;
1321:
1322: --removed code causing error for closed, in-transit dels
1323:
1324: IF l_delivery_type = 'STANDARD' THEN
1325:
1326: OPEN delivery_details;
1327: FETCH delivery_details INTO l_detail_id;
1328:

Line 3864: AND nd.delivery_type = 'STANDARD'

3860: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3861: WHERE dg.pick_up_stop_id = l_stop_id
3862: AND dg.delivery_id <> l_delivery_id
3863: AND dg.delivery_id = nd.delivery_id
3864: AND nd.delivery_type = 'STANDARD'
3865: UNION
3866: SELECT dg.delivery_leg_id
3867: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3868: WHERE dg.drop_off_stop_id = l_stop_id

Line 3871: AND nd.delivery_type = 'STANDARD';

3867: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3868: WHERE dg.drop_off_stop_id = l_stop_id
3869: AND dg.delivery_id <> l_delivery_id
3870: AND dg.delivery_id = nd.delivery_id
3871: AND nd.delivery_type = 'STANDARD';
3872:
3873: -- bug 2429322: check that all stops are closed when
3874: -- automatically closing delivery.
3875: -- Sufficient to check drop off stops only;

Line 4220: AND wnd.delivery_type = 'STANDARD'

4216: SELECT 1
4217: FROM wsh_delivery_legs wdl1, wsh_new_deliveries wnd
4218: WHERE wdl1.delivery_id <> p_delivery_id
4219: AND wdl1.delivery_id = wnd.delivery_id
4220: AND wnd.delivery_type = 'STANDARD'
4221: AND (
4222: wdl1.pick_up_stop_id = wts.stop_id
4223: OR wdl1.drop_off_stop_id = wts.stop_id
4224: )

Line 4725: IF (l_flag = 'Y') and l_delivery_type = 'STANDARD' THEN

4721: FOR dt IN leg_info LOOP
4722: l_flag := 'Y';
4723: END LOOP;
4724:
4725: IF (l_flag = 'Y') and l_delivery_type = 'STANDARD' THEN
4726: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DELETE_WITH_LEGS');
4727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4728: --
4729: -- Debug Statements

Line 12124: -- Bug 3613650 - Need not compare standard WHO columns

12120: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE20, ';
12121: END IF;
12122:
12123: /**
12124: -- Bug 3613650 - Need not compare standard WHO columns
12125: --
12126: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE
12127: AND NVL(p_user_in_rec.CREATION_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CREATION_DATE,TO_DATE('2','j'))
12128: THEN