APPS.RCV_NORMALIZE_DATA_PKG dependencies on WMS_LPN_CONTENTS_INTERFACE

Line 380: FROM wms_lpn_contents_interface));

376: AND ( lpn_group_id IS NOT NULL
377: OR lpn_id IS NOT NULL
378: OR license_plate_number IS NOT NULL
379: OR interface_transaction_id IN (SELECT interface_transaction_id
380: FROM wms_lpn_contents_interface));
381: ELSE
382: UPDATE rcv_transactions_interface
383: SET processing_status_code = 'RUNNING',
384: processing_request_id = g_request_id

Line 393: FROM wms_lpn_contents_interface));

389: AND ( lpn_group_id IS NOT NULL
390: OR lpn_id IS NOT NULL
391: OR license_plate_number IS NOT NULL
392: OR interface_transaction_id IN (SELECT interface_transaction_id
393: FROM wms_lpn_contents_interface));
394:
395: END IF;
396:
397:

Line 448: FROM wms_lpn_contents_interface));

444: AND ( lpn_group_id IS NOT NULL
445: OR lpn_id IS NOT NULL
446: OR license_plate_number IS NOT NULL
447: OR interface_transaction_id IN (SELECT interface_transaction_id
448: FROM wms_lpn_contents_interface));
449: ELSE
450: UPDATE rcv_transactions_interface
451: SET processing_status_code = 'RUNNING',
452: processing_request_id = g_request_id,

Line 463: FROM wms_lpn_contents_interface));

459: AND ( lpn_group_id IS NOT NULL
460: OR lpn_id IS NOT NULL
461: OR license_plate_number IS NOT NULL
462: OR interface_transaction_id IN (SELECT interface_transaction_id
463: FROM wms_lpn_contents_interface));
464:
465: END IF;
466:
467: inv_rcv_integration_apis.explode_lpn(1.0,