DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_HISTORY_PKG dependencies on WSH_NEW_DELIVERIES

Line 53: FROM wsh_new_deliveries wnd,

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