APPS.QA_ERES_SHIPPING dependencies on EDR_PSIG_DOCUMENTS

Line 84: FROM EDR_PSIG_DOCUMENTS epd

80: AND (wnd.status_code = 'IT' OR wnd.status_code = 'CL')
81: AND nvl(wnd.shipment_direction, 'O') in ('O') --BUG 3763874
82: AND NOT EXISTS
83: (SELECT 1
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

Line 92: --EDR_PSIG_DOCUMENTS_N1 - on event_name and event_key

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;
95: out_status VARCHAR2(50) := FND_API.G_RET_STS_SUCCESS;
96: