APPS.WSH_DELIVERY_VALIDATIONS dependencies on STANDARD

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

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','INCLUDED');--Bug10166876
233: --Bug 10166876 : Item_type_code is populated as 'Included' for order lines with ATO Item,
234: -- which are included in PTO Model(If non-Optional in BOM) or KIT Model.
235: -- Lines with item_type_code as 'Standard' ,'Option' or 'Included' should be
236: -- excluded for validation of ATO Configurations.

Line 235: -- Lines with item_type_code as 'Standard' ,'Option' or 'Included' should be

231: AND ato_line_id = line_id
232: AND item_type_code NOT IN ('STANDARD','OPTION','INCLUDED');--Bug10166876
233: --Bug 10166876 : Item_type_code is populated as 'Included' for order lines with ATO Item,
234: -- which are included in PTO Model(If non-Optional in BOM) or KIT Model.
235: -- Lines with item_type_code as 'Standard' ,'Option' or 'Included' should be
236: -- excluded for validation of ATO Configurations.
237:
238:
239: l_detail_id NUMBER;

Line 1351: IF l_delivery_type = 'STANDARD' THEN

1347: END IF;
1348:
1349: --removed code causing error for closed, in-transit dels
1350:
1351: IF l_delivery_type = 'STANDARD' THEN
1352:
1353: OPEN delivery_details;
1354: FETCH delivery_details INTO l_detail_id;
1355:

Line 3954: AND nd.delivery_type = 'STANDARD'

3950: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3951: WHERE dg.pick_up_stop_id = l_stop_id
3952: AND dg.delivery_id <> l_delivery_id
3953: AND dg.delivery_id = nd.delivery_id
3954: AND nd.delivery_type = 'STANDARD'
3955: UNION
3956: SELECT dg.delivery_leg_id
3957: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3958: WHERE dg.drop_off_stop_id = l_stop_id

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

3957: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3958: WHERE dg.drop_off_stop_id = l_stop_id
3959: AND dg.delivery_id <> l_delivery_id
3960: AND dg.delivery_id = nd.delivery_id
3961: AND nd.delivery_type = 'STANDARD';
3962:
3963: -- bug 2429322: check that all stops are closed when
3964: -- automatically closing delivery.
3965: -- Sufficient to check drop off stops only;

Line 4310: AND wnd.delivery_type = 'STANDARD'

4306: SELECT 1
4307: FROM wsh_delivery_legs wdl1, wsh_new_deliveries wnd
4308: WHERE wdl1.delivery_id <> p_delivery_id
4309: AND wdl1.delivery_id = wnd.delivery_id
4310: AND wnd.delivery_type = 'STANDARD'
4311: AND (
4312: wdl1.pick_up_stop_id = wts.stop_id
4313: OR wdl1.drop_off_stop_id = wts.stop_id
4314: )

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

4811: FOR dt IN leg_info LOOP
4812: l_flag := 'Y';
4813: END LOOP;
4814:
4815: IF (l_flag = 'Y') and l_delivery_type = 'STANDARD' THEN
4816: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DELETE_WITH_LEGS');
4817: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4818: --
4819: -- Debug Statements

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

12392: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE20, ';
12393: END IF;
12394:
12395: /**
12396: -- Bug 3613650 - Need not compare standard WHO columns
12397: --
12398: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE
12399: AND NVL(p_user_in_rec.CREATION_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CREATION_DATE,TO_DATE('2','j'))
12400: THEN