DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_BATCH_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 303: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

299: l_batch_tbl WSH_UTIL_CORE.Id_Tab_Type;
300: --Fulfillment Batch XML Project --Start
301: l_raise_batch_tbl WSH_UTIL_CORE.Id_Tab_Type;
302: l_be_return_status VARCHAR2(1);
303: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
304: wsh_raise_event_error EXCEPTION;
305: l_dist_src_entity_profile VARCHAR2 (10);
306: l_dist_flag VARCHAR2 (1);
307: --Fulfillment Batch XML Project --End

Line 1117: wsh_transactions_history wth,

1113: select src_requested_quantity,
1114: requested_quantity,
1115: delivery_detail_id
1116: from wsh_delivery_details wdd,
1117: wsh_transactions_history wth,
1118: wsh_shipment_batches wsb
1119: where source_code = 'OE'
1120: and released_status in ( 'R', 'B', 'X' )
1121: and wdd.shipment_batch_id = wsb.batch_id