APPS.WMS_TASK_LOAD dependencies on INV_GLOBALS

Line 5344: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;

5340: WHERE (mmtt.transaction_temp_id = p_transaction_temp_id
5341: -- shld add : and mmtt.mmtt.transaction_temp_id <> mmtt.parent_line_id
5342: OR mmtt.parent_line_id = p_transaction_temp_id)
5343: AND mtrl.line_id = mmtt.move_order_line_id
5344: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;
5345:
5346: -- all mmtts for the given MOL
5347: -- this MMTT should not have any child records
5348: -- this MMTT should not have a task in WDT

Line 5421: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)

5417:
5418: UPDATE mtl_txn_request_lines
5419: SET quantity_detailed =(quantity_detailed - l_deleted_mmtt_qty)
5420: , SECONDARY_QUANTITY_DETAILED = (SECONDARY_QUANTITY_DETAILED - l_deleted_mmtt_sec_qty)
5421: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)
5422: , last_update_date = SYSDATE
5423: , last_updated_by = p_user_id
5424: WHERE line_id = rec_cancelled_mols.line_id;
5425: IF SQL%NOTFOUND THEN

Line 10319: AND mol.line_status = inv_globals.g_to_status_cancel_by_source

10315: SELECT 'FAIL'
10316: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
10317: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
10318: AND mmtt.move_order_line_id = mol.line_id
10319: AND mol.line_status = inv_globals.g_to_status_cancel_by_source
10320: AND ROWNUM = 1;
10321: BEGIN
10322: g_debug := l_debug;
10323: mydebug('In CAN_PICKDROP for Transaction Temp ID = ' || p_transaction_temp_id);