APPS.WMS_TASK_LOAD dependencies on INV_GLOBALS

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

6577: WHERE (mmtt.transaction_temp_id = p_transaction_temp_id
6578: -- shld add : and mmtt.mmtt.transaction_temp_id <> mmtt.parent_line_id
6579: OR mmtt.parent_line_id = p_transaction_temp_id)
6580: AND mtrl.line_id = mmtt.move_order_line_id
6581: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;
6582:
6583: -- all mmtts for the given MOL
6584: -- this MMTT should not have any child records
6585: -- this MMTT should not have a task in WDT

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

6654:
6655: UPDATE mtl_txn_request_lines
6656: SET quantity_detailed =(quantity_detailed - l_deleted_mmtt_qty)
6657: , SECONDARY_QUANTITY_DETAILED = (SECONDARY_QUANTITY_DETAILED - l_deleted_mmtt_sec_qty)
6658: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)
6659: , last_update_date = SYSDATE
6660: , last_updated_by = p_user_id
6661: WHERE line_id = rec_cancelled_mols.line_id;
6662: IF SQL%NOTFOUND THEN

Line 12609: AND mol.line_status = inv_globals.g_to_status_cancel_by_source

12605: SELECT 'FAIL'
12606: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
12607: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
12608: AND mmtt.move_order_line_id = mol.line_id
12609: AND mol.line_status = inv_globals.g_to_status_cancel_by_source
12610: AND ROWNUM = 1;
12611: BEGIN
12612: g_debug := l_debug;
12613: mydebug('In CAN_PICKDROP for Transaction Temp ID = ' || p_transaction_temp_id);