DBA Data[Home] [Help]

APPS.CSD_LOGISTICS_UTIL dependencies on WSH_PICKING_RULES

Line 2184: FROM wsh_picking_rules

2180:
2181: --R12 Development Changes Begin
2182: CURSOR cur_pick_rules(p_pick_rule_id NUMBER) IS
2183: SELECT 'x'
2184: FROM wsh_picking_rules
2185: WHERE picking_rule_id = p_pick_rule_id
2186: AND SYSDATE BETWEEN NVL(start_Date_Active, SYSDATE) AND
2187: NVL(end_Date_active, SYSDATE + 1);
2188: --R12 Development Changes End

Line 3413: FROM WSH_PICKING_RULES

3409:
3410: BEGIN
3411: SELECT PICKING_RULE_ID
3412: INTO l_picking_rule_id
3413: FROM WSH_PICKING_RULES
3414: WHERE picking_rule_id = l_picking_rule_id
3415: AND SYSDATE BETWEEN
3416: NVL(START_DATE_ACTIVE, SYSDATE) AND
3417: NVL(END_DATE_ACTIVE, SYSDATE + 1);