2931: UPDATE wms_dispatched_tasks
2932: SET status = g_task_status_loaded,
2933: loaded_time = Sysdate,
2934: last_update_date = Sysdate,
2935: last_updated_by = fnd_global.user_id
2936: WHERE task_id = l_wdt_task_id;
2937:
2938: l_progress := 70;
2939:
5288: , dispatched_time
5289: , loaded_time
5290: , drop_off_time
5291: , SYSDATE
5292: , FND_GLOBAL.USER_ID
5293: , creation_date
5294: , created_by
5295: , fnd_global.USER_ID
5296: , attribute_category
5291: , SYSDATE
5292: , FND_GLOBAL.USER_ID
5293: , creation_date
5294: , created_by
5295: , fnd_global.USER_ID
5296: , attribute_category
5297: , attribute1
5298: , attribute2
5299: , attribute3
5491: , territory_code
5492: )
5493: SELECT l_inbound_doc_parent_rec.transaction_temp_id
5494: , SYSDATE
5495: , FND_GLOBAL.USER_ID
5496: , SYSDATE
5497: , FND_GLOBAL.USER_ID
5498: , l_inbound_doc_parent_rec.transaction_quantity
5499: , l_inbound_doc_parent_rec.primary_quantity
5493: SELECT l_inbound_doc_parent_rec.transaction_temp_id
5494: , SYSDATE
5495: , FND_GLOBAL.USER_ID
5496: , SYSDATE
5497: , FND_GLOBAL.USER_ID
5498: , l_inbound_doc_parent_rec.transaction_quantity
5499: , l_inbound_doc_parent_rec.primary_quantity
5500: , secondary_quantity
5501: , secondary_unit_of_measure
5753: , territory_code
5754: )
5755: SELECT l_inbound_doc_parent_split_rec.transaction_temp_id
5756: , SYSDATE
5757: , FND_GLOBAL.USER_ID
5758: , SYSDATE
5759: , FND_GLOBAL.USER_ID
5760: , l_inbound_doc_parent_split_rec.transaction_quantity
5761: , l_inbound_doc_parent_split_rec.primary_quantity
5755: SELECT l_inbound_doc_parent_split_rec.transaction_temp_id
5756: , SYSDATE
5757: , FND_GLOBAL.USER_ID
5758: , SYSDATE
5759: , FND_GLOBAL.USER_ID
5760: , l_inbound_doc_parent_split_rec.transaction_quantity
5761: , l_inbound_doc_parent_split_rec.primary_quantity
5762: , l_inbound_doc_parent_split_rec.secondary_transaction_quantity -- 9037915
5763: , secondary_unit_of_measure
5995: , dispatched_time
5996: , loaded_time
5997: , drop_off_time
5998: , SYSDATE
5999: , fnd_global.user_id
6000: , SYSDATE -- bug 3827507
6001: , fnd_global.user_id -- bug 3827507
6002: , fnd_global.user_id
6003: , attribute_category
5997: , drop_off_time
5998: , SYSDATE
5999: , fnd_global.user_id
6000: , SYSDATE -- bug 3827507
6001: , fnd_global.user_id -- bug 3827507
6002: , fnd_global.user_id
6003: , attribute_category
6004: , attribute1
6005: , attribute2
5998: , SYSDATE
5999: , fnd_global.user_id
6000: , SYSDATE -- bug 3827507
6001: , fnd_global.user_id -- bug 3827507
6002: , fnd_global.user_id
6003: , attribute_category
6004: , attribute1
6005: , attribute2
6006: , attribute3
6295: , dispatched_time
6296: , loaded_time
6297: , drop_off_time
6298: , SYSDATE
6299: , FND_GLOBAL.USER_ID
6300: , creation_date
6301: , created_by
6302: , fnd_global.USER_ID
6303: , attribute_category
6298: , SYSDATE
6299: , FND_GLOBAL.USER_ID
6300: , creation_date
6301: , created_by
6302: , fnd_global.USER_ID
6303: , attribute_category
6304: , attribute1
6305: , attribute2
6306: , attribute3