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.

[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WMS_EXCEPTIONS

Line 4901: -- Have to update WMS_Exceptions so that any exceptions already

4897: mydebug('complete_putaway: after updating mmtt with content lpn');
4898: END IF;
4899: END IF;--END IF (p_entire_lpn = 'N') THEN
4900:
4901: -- Have to update WMS_Exceptions so that any exceptions already
4902: -- recorded for this MMTT line will now be updated with the new txn
4903: -- header_id
4904: -- Bug# 3434940 - Performance Fixes
4905: -- Go against the org and item which are input params for

Line 4907: -- WMS_EXCEPTIONS

4903: -- header_id
4904: -- Bug# 3434940 - Performance Fixes
4905: -- Go against the org and item which are input params for
4906: -- complete_putaway since this will make use of the index in
4907: -- WMS_EXCEPTIONS
4908: UPDATE wms_exceptions
4909: SET transaction_header_id = l_txn_header_id
4910: WHERE transaction_header_id = l_orig_txn_header_id
4911: AND organization_id = p_org_id

Line 4908: UPDATE wms_exceptions

4904: -- Bug# 3434940 - Performance Fixes
4905: -- Go against the org and item which are input params for
4906: -- complete_putaway since this will make use of the index in
4907: -- WMS_EXCEPTIONS
4908: UPDATE wms_exceptions
4909: SET transaction_header_id = l_txn_header_id
4910: WHERE transaction_header_id = l_orig_txn_header_id
4911: AND organization_id = p_org_id
4912: AND inventory_item_id = p_item_id;

Line 5355: -- Have to update WMS_Exceptions so that any excpetions already

5351:
5352: END IF; --END IF (p_lpn_id = l_to_lpn_id) THEN
5353:
5354:
5355: -- Have to update WMS_Exceptions so that any excpetions already
5356: -- recorded for this MMTT line will now be updated with the new txn
5357: -- header_id
5358: -- Bug# 3434940 - Performance Fixes
5359: -- Go against the org and item which are input params for

Line 5361: -- WMS_EXCEPTIONS

5357: -- header_id
5358: -- Bug# 3434940 - Performance Fixes
5359: -- Go against the org and item which are input params for
5360: -- complete_putaway since this will make use of the index in
5361: -- WMS_EXCEPTIONS
5362: UPDATE wms_exceptions
5363: SET transaction_header_id = l_txn_header_id
5364: WHERE transaction_header_id = l_orig_txn_header_id
5365: AND organization_id = p_org_id

Line 5362: UPDATE wms_exceptions

5358: -- Bug# 3434940 - Performance Fixes
5359: -- Go against the org and item which are input params for
5360: -- complete_putaway since this will make use of the index in
5361: -- WMS_EXCEPTIONS
5362: UPDATE wms_exceptions
5363: SET transaction_header_id = l_txn_header_id
5364: WHERE transaction_header_id = l_orig_txn_header_id
5365: AND organization_id = p_org_id
5366: AND inventory_item_id = p_item_id;

Line 6584: SELECT wms_exceptions_s.NEXTVAL

6580:
6581: -- Log exception
6582:
6583: --Calculate Sequence Number
6584: SELECT wms_exceptions_s.NEXTVAL
6585: INTO l_sequence
6586: FROM DUAL;
6587:
6588: IF (l_debug = 1) THEN

Line 6593: INSERT INTO wms_exceptions

6589: mydebug('Inserting into exceptions');
6590: mydebug(l_sequence);
6591: END IF;
6592:
6593: INSERT INTO wms_exceptions
6594: (
6595: task_id
6596: , sequence_number
6597: , organization_id