APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 181: FROM wsh_transactions_history wth

177: /* Check if the current record is a duplicate */
178: BEGIN
179: SELECT 'X'
180: INTO p_duplicate
181: FROM wsh_transactions_history wth
182: WHERE wth.document_type = p_doc_type
183: AND wth.document_number = p_doc_number
184: AND wth.action_type = p_action_type
185: AND wth.trading_partner_id = x_trading_partner_id

Line 234: FROM wsh_transactions_history

230: IF (l_wms_deployment_mode = 'D' OR (l_wms_deployment_mode = 'L' AND p_client_code IS NOT NULL)) THEN ----{ LSP PROJECT : consider LSP mode also
231:
232: SELECT 'X'
233: INTO p_940_exists
234: FROM wsh_transactions_history
235: WHERE document_number = p_doc_number
236: AND document_type = 'SR'
237: AND document_direction = 'I'
238: AND action_type in ('A', 'C')

Line 243: FROM wsh_transactions_history

239: AND rownum = 1;
240: ELSE
241: SELECT 'X'
242: INTO p_940_exists
243: FROM wsh_transactions_history
244: WHERE document_number = p_orig_document_number
245: AND document_type = 'SR'
246: AND document_direction = 'I'
247: AND action_type = 'A';

Line 283: FROM wsh_transactions_history

279: /* Check if the Corresponding 940 Out exists when a 945 Comes in */
280: BEGIN
281: SELECT 'X'
282: INTO p_940_exists
283: FROM wsh_transactions_history
284: WHERE document_number = p_orig_document_number
285: AND document_type = 'SR'
286: AND document_direction = 'O'
287: AND action_type = 'A';

Line 705: wsh_transactions_history wth

701: INTO l_delivery_detail_exists
702: FROM wsh_delivery_details wdd,
703: wsh_delivery_assignments wda,
704: wsh_shipment_batches wsb,
705: wsh_transactions_history wth
706: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
707: AND wdd.shipment_line_number = delivery_detail_int_rec.delivery_detail_id
708: AND wdd.released_status in ('R','B','X')--Fulfillment Batch XML Gateway Project
709: AND wdd.source_code = 'OE'