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.

APPS.INV_RCV_INTEGRATION_PVT dependencies on INV_GLOBALS

Line 286: AND line_status <> inv_globals.G_TO_STATUS_CLOSED

282: WHERE mtrl.lpn_id = p_lpn_id
283: AND mtrl.organization_id = p_org_id
284: AND (Nvl(mtrl.project_id,-1) <> Nvl(p_project_id,-1)
285: OR Nvl(mtrl.task_id,-1) <> Nvl(p_task_id,-1))
286: AND line_status <> inv_globals.G_TO_STATUS_CLOSED
287: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0);
288:
289: RETURN TRUE;
290:

Line 3934: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED

3930: AND Nvl(mtrl.lot_number, Nvl(p_lot,'@$#_')) = Nvl(p_lot, '@$#_')
3931: AND mmtt.transaction_temp_id = p_mmtt_id
3932: AND mmtt.move_order_line_id = mtrl.line_id
3933: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
3934: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3935: AND exists (SELECT 1
3936: FROM mtl_txn_request_headers mtrh
3937: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3938: AND mtrh.header_id = mtrl.header_id)

Line 3937: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

3933: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
3934: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3935: AND exists (SELECT 1
3936: FROM mtl_txn_request_headers mtrh
3937: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3938: AND mtrh.header_id = mtrl.header_id)
3939: ORDER BY 3 DESC;
3940:
3941: l_mol_rec c_mol_mmtt%ROWTYPE;

Line 4008: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED

4004: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
4005: AND mmtt.move_order_line_id (+) = mtrl.line_id
4006: AND mtrl.reference_id = p_new_reference_id --14133874
4007: AND mmtt.organization_id (+) = mtrl.organization_id
4008: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4009: AND exists (SELECT 1
4010: FROM mtl_txn_request_headers mtrh
4011: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4012: AND mtrh.header_id = mtrl.header_id)

Line 4011: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

4007: AND mmtt.organization_id (+) = mtrl.organization_id
4008: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4009: AND exists (SELECT 1
4010: FROM mtl_txn_request_headers mtrh
4011: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4012: AND mtrh.header_id = mtrl.header_id)
4013: ORDER BY 2, 3 DESC, 4 DESC, 5;--order on 3 should be DESC because,
4014: --if it is not, NULL values wouuld come last
4015:

Line 4066: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED

4062: AND Nvl(task_id,-1) = Nvl(p_task_id,-1)
4063: AND Nvl(backorder_delivery_detail_id,-1) = Nvl(p_backorder_delivery_detail_id,-1)
4064: AND Nvl(crossdock_type,-1) = Nvl(p_crossdock_type,-1)
4065: -- AND Nvl(from_cost_group_id,-1) = Nvl(p_cost_group_id,-1) ????
4066: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4067: AND exists (SELECT 1
4068: FROM mtl_txn_request_headers mtrh
4069: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4070: AND mtrh.header_id = mtrl.header_id)

Line 4069: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

4065: -- AND Nvl(from_cost_group_id,-1) = Nvl(p_cost_group_id,-1) ????
4066: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4067: AND exists (SELECT 1
4068: FROM mtl_txn_request_headers mtrh
4069: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4070: AND mtrh.header_id = mtrl.header_id)
4071: ORDER BY 2,3 DESC, 4 ;
4072:
4073: l_transfer_mol_rec c_transfer_mol%rowtype;

Line 5747: SET line_status = inv_globals.G_TO_STATUS_CLOSED

5743: print_debug('MAINTAIN_MO_CON - before updating mol update or close = C ',1);
5744: END IF;
5745:
5746: UPDATE mtl_txn_request_lines
5747: SET line_status = inv_globals.G_TO_STATUS_CLOSED
5748: , quantity = Nvl(quantity_delivered,0)
5749: , quantity_detailed = quantity_delivered
5750: , secondary_quantity_detailed = SECONDARY_QUANTITY_DELIVERED
5751: --BDD_ID will get NULL out for REJECT cases

Line 6051: SET line_status = inv_globals.G_TO_STATUS_CLOSED

6047: --updated just like the crossdock mols.
6048:
6049: IF (l_update_or_close = 'C') THEN
6050: UPDATE mtl_txn_request_lines
6051: SET line_status = inv_globals.G_TO_STATUS_CLOSED
6052: , quantity = quantity_delivered
6053: , quantity_detailed = quantity_delivered
6054: , secondary_quantity_detailed = SECONDARY_QUANTITY_DELIVERED
6055: , wms_process_flag = 1

Line 6757: inv_globals.G_TO_STATUS_CLOSED,line_status),line_status)

6753: ,secondary_quantity_delivered = Decode(p_mmtt_temp_id,NULL,
6754: Nvl(secondary_quantity_delivered,0)+l_sec_quantity_delivered,quantity_delivered)
6755: , line_status = Decode(p_mmtt_temp_id,NULL,
6756: Decode((Nvl(quantity_delivered,0)+l_quantity_delivered),quantity,
6757: inv_globals.G_TO_STATUS_CLOSED,line_status),line_status)
6758: , wms_process_flag = 1
6759: WHERE line_id = l_mo_split_tb(1).line_id;
6760:
6761: -- R12

Line 6828: , line_status = Decode(p_mmtt_temp_id,NULL,inv_globals.g_to_status_closed,line_status)

6824: SET quantity_delivered = Decode(p_mmtt_temp_id,NULL,quantity,quantity_delivered)
6825: -- OPMConvergence
6826: , secondary_quantity_delivered = Decode(p_mmtt_temp_id,NULL,secondary_quantity,secondary_quantity_delivered)
6827: -- OPMConvergence
6828: , line_status = Decode(p_mmtt_temp_id,NULL,inv_globals.g_to_status_closed,line_status)
6829: , wms_process_flag = 1
6830: WHERE line_id = l_mol_rec.line_id;
6831:
6832: -- OPMConvergence

Line 11671: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

11667: AND mtrl.line_status = 7
11668: AND mtrl.quantity-Nvl(mtrl.quantity_delivered,0) > 0
11669: AND exists (SELECT 1
11670: FROM mtl_txn_request_headers mtrh
11671: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
11672: AND mtrh.header_id = mtrl.header_id);
11673:
11674: TYPE mol_mmtt_ctnt_tb_tp IS TABLE OF c_mol_mmtt_ctnt_cur%ROWTYPE;
11675: l_mol_mmtt_ctnt_tb mol_mmtt_ctnt_tb_tp;