eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIPMENT_ADVICE_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 163: from wsh_transactions_history

159: --Fulfillment Batch XML Project
160: cursor c_get_status (c_trx_id NUMBER)
161: is
162: select transaction_status
163: from wsh_transactions_history
164: where transaction_id = c_trx_id;
165:
166: CURSOR C_Get_One_Transactions
167: IS

Line 201: FROM Wsh_Transactions_History wth,

197: wth.Attribute13,
198: wth.Attribute14,
199: wth.Attribute15,
200: null
201: FROM Wsh_Transactions_History wth,
202: Wsh_New_Del_Interface wndi
203: WHERE wndi.interface_action_code = g_interface_action_code
204: AND wndi.delivery_interface_id = to_number(wth.entity_number)
205: AND wth.transaction_id = p_transaction_id

Line 208: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

204: AND wndi.delivery_interface_id = to_number(wth.entity_number)
205: AND wth.transaction_id = p_transaction_id
206: AND wth.transaction_status = nvl(p_transaction_status, wth.transaction_status);
207:
208: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
209: l_trx_status wsh_transactions_history.transaction_status%TYPE;
210:
211: l_from_creation_date DATE;
212: l_to_creation_date DATE;

Line 209: l_trx_status wsh_transactions_history.transaction_status%TYPE;

205: AND wth.transaction_id = p_transaction_id
206: AND wth.transaction_status = nvl(p_transaction_status, wth.transaction_status);
207:
208: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
209: l_trx_status wsh_transactions_history.transaction_status%TYPE;
210:
211: l_from_creation_date DATE;
212: l_to_creation_date DATE;
213:

Line 305: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth, ';

301: l_transaction_query := l_transaction_query || 'wth.Attribute14, ';
302: l_transaction_query := l_transaction_query || 'wth.Attribute15 ';
303:
304: --FROM Clause
305: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth, ';
306: l_transaction_query := l_transaction_query || ' Wsh_New_Del_Interface wndi ';
307: l_transaction_query := l_transaction_query || ' WHERE wth.document_type = ''SA'' ';
308: l_transaction_query := l_transaction_query || ' AND wth.document_direction = ''I'' ';
309: