APPS.QA_ERES_SHIPPING dependencies on WSH_NEW_DELIVERIES

Line 77: FROM wsh_new_deliveries wnd

73:
74: CURSOR wsh_delivery_cur(c_from_date DATE, c_to_date DATE,
75: c_evt_name VARCHAR2) IS
76: SELECT wnd.delivery_id, wnd.name
77: FROM wsh_new_deliveries wnd
78: WHERE wnd.initial_pickup_date >= c_from_date
79: AND wnd.initial_pickup_date <= c_to_date
80: AND (wnd.status_code = 'IT' OR wnd.status_code = 'CL')
81: AND nvl(wnd.shipment_direction, 'O') in ('O') --BUG 3763874

Line 88: --following indexes exist on wsh_new_deliveries table

84: FROM EDR_PSIG_DOCUMENTS epd
85: WHERE epd.event_name = c_evt_name
86: AND epd.event_key = wnd.delivery_id
87: AND epd.psig_status = 'COMPLETE');
88: --following indexes exist on wsh_new_deliveries table
89: --WSH_NEW_DELIVERIES_N1 - on wnd.status_code column
90: --WSH_NEW_DELIVERIES_N7 - on initial_pickup_date column
91: --following indexes exist on EDR table
92: --EDR_PSIG_DOCUMENTS_N1 - on event_name and event_key

Line 89: --WSH_NEW_DELIVERIES_N1 - on wnd.status_code column

85: WHERE epd.event_name = c_evt_name
86: AND epd.event_key = wnd.delivery_id
87: AND epd.psig_status = 'COMPLETE');
88: --following indexes exist on wsh_new_deliveries table
89: --WSH_NEW_DELIVERIES_N1 - on wnd.status_code column
90: --WSH_NEW_DELIVERIES_N7 - on initial_pickup_date column
91: --following indexes exist on EDR table
92: --EDR_PSIG_DOCUMENTS_N1 - on event_name and event_key
93:

Line 90: --WSH_NEW_DELIVERIES_N7 - on initial_pickup_date column

86: AND epd.event_key = wnd.delivery_id
87: AND epd.psig_status = 'COMPLETE');
88: --following indexes exist on wsh_new_deliveries table
89: --WSH_NEW_DELIVERIES_N1 - on wnd.status_code column
90: --WSH_NEW_DELIVERIES_N7 - on initial_pickup_date column
91: --following indexes exist on EDR table
92: --EDR_PSIG_DOCUMENTS_N1 - on event_name and event_key
93:
94: out_erecord_id NUMBER;