DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_TRANSACTIONS_HISTORY

Line 6413: from wsh_transactions_history

6409: cursor valid_shpmnt_advice_cur(p_delivery_id IN NUMBER,
6410: p_tp_id IN NUMBER
6411: ) is
6412: select 'X'
6413: from wsh_transactions_history
6414: where transaction_id = (
6415: select max(transaction_id)
6416: from wsh_transactions_history wth,
6417: wsh_new_deliveries wnd

Line 6416: from wsh_transactions_history wth,

6412: select 'X'
6413: from wsh_transactions_history
6414: where transaction_id = (
6415: select max(transaction_id)
6416: from wsh_transactions_history wth,
6417: wsh_new_deliveries wnd
6418: where wth.entity_number = wnd.name
6419: and wth.trading_partner_id = p_tp_id
6420: and wnd.delivery_id = p_delivery_id