DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_FORM_PKG dependencies on WSH_NEW_DEL_INTERFACE

Line 97: WSH_NEW_DEL_INTERFACE wndi

93: SELECT wth.document_type,wth.document_number,wth.orig_document_number,wth.document_direction,wth.transaction_status,wth.
94: action_type,wth.entity_number,wth.entity_type,wth.trading_partner_id,wth.ecx_message_id,wth.
95: event_name,wth.event_key,wth.internal_control_number,wth.item_type,wndi.client_code
96: FROM WSH_TRANSACTIONS_HISTORY wth,
97: WSH_NEW_DEL_INTERFACE wndi
98: WHERE wth.transaction_id = P_transaction_id
99: AND wth.entity_number = wndi.delivery_interface_id(+);
100:
101: cursor c_get_status (v_trx_id NUMBER)