DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_HISTORY_PKG dependencies on WSH_NEW_DELIVERIES

Line 52: FROM wsh_new_deliveries wnd,

48: l_return_status VARCHAR2(2);
49:
50: CURSOR c_get_del_status (v_doc_number varchar2) IS
51: SELECT wnd.status_code
52: FROM wsh_new_deliveries wnd,
53: wsh_transactions_history wth
54: WHERE wth.document_number = v_doc_number
55: AND wth.entity_type = 'DLVY'
56: AND wth.document_type = 'SR'