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 276: AND line_status <> inv_globals.G_TO_STATUS_CLOSED

272: WHERE mtrl.lpn_id = p_lpn_id
273: AND mtrl.organization_id = p_org_id
274: AND (Nvl(mtrl.project_id,-1) <> Nvl(p_project_id,-1)
275: OR Nvl(mtrl.task_id,-1) <> Nvl(p_task_id,-1))
276: AND line_status <> inv_globals.G_TO_STATUS_CLOSED
277: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0);
278:
279: RETURN TRUE;
280:

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

3874: AND Nvl(mtrl.lot_number, Nvl(p_lot,'@$#_')) = Nvl(p_lot, '@$#_')
3875: AND mmtt.transaction_temp_id = p_mmtt_id
3876: AND mmtt.move_order_line_id = mtrl.line_id
3877: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
3878: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3879: AND exists (SELECT 1
3880: FROM mtl_txn_request_headers mtrh
3881: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3882: AND mtrh.header_id = mtrl.header_id)

Line 3881: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

3877: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
3878: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3879: AND exists (SELECT 1
3880: FROM mtl_txn_request_headers mtrh
3881: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3882: AND mtrh.header_id = mtrl.header_id)
3883: ORDER BY 3 DESC;
3884:
3885: l_mol_rec c_mol_mmtt%ROWTYPE;

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

3945: AND Nvl(mtrl.lot_number, Nvl(p_lot,'@$#_')) = Nvl(p_lot, '@$#_')
3946: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
3947: AND mmtt.move_order_line_id (+) = mtrl.line_id
3948: AND mmtt.organization_id (+) = mtrl.organization_id
3949: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3950: AND exists (SELECT 1
3951: FROM mtl_txn_request_headers mtrh
3952: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3953: AND mtrh.header_id = mtrl.header_id)

Line 3952: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

3948: AND mmtt.organization_id (+) = mtrl.organization_id
3949: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3950: AND exists (SELECT 1
3951: FROM mtl_txn_request_headers mtrh
3952: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3953: AND mtrh.header_id = mtrl.header_id)
3954: ORDER BY 2, 3 DESC, 4 DESC, 5;--order on 3 should be DESC because,
3955: --if it is not, NULL values wouuld come last
3956:

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

3998: AND Nvl(task_id,-1) = Nvl(p_task_id,-1)
3999: AND Nvl(backorder_delivery_detail_id,-1) = Nvl(p_backorder_delivery_detail_id,-1)
4000: AND Nvl(crossdock_type,-1) = Nvl(p_crossdock_type,-1)
4001: -- AND Nvl(from_cost_group_id,-1) = Nvl(p_cost_group_id,-1) ????
4002: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4003: AND exists (SELECT 1
4004: FROM mtl_txn_request_headers mtrh
4005: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4006: AND mtrh.header_id = mtrl.header_id)

Line 4005: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

4001: -- AND Nvl(from_cost_group_id,-1) = Nvl(p_cost_group_id,-1) ????
4002: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4003: AND exists (SELECT 1
4004: FROM mtl_txn_request_headers mtrh
4005: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4006: AND mtrh.header_id = mtrl.header_id)
4007: ORDER BY 2,3 DESC, 4 ;
4008:
4009: l_transfer_mol_rec c_transfer_mol%rowtype;

Line 5628: SET line_status = inv_globals.G_TO_STATUS_CLOSED

5624: print_debug('MAINTAIN_MO_CON - before updating mol update or close = C ',1);
5625: END IF;
5626:
5627: UPDATE mtl_txn_request_lines
5628: SET line_status = inv_globals.G_TO_STATUS_CLOSED
5629: , quantity = Nvl(quantity_delivered,0)
5630: , quantity_detailed = quantity_delivered
5631: , secondary_quantity_detailed = SECONDARY_QUANTITY_DELIVERED
5632: --BDD_ID will get NULL out for REJECT cases

Line 5914: SET line_status = inv_globals.G_TO_STATUS_CLOSED

5910: --updated just like the crossdock mols.
5911:
5912: IF (l_update_or_close = 'C') THEN
5913: UPDATE mtl_txn_request_lines
5914: SET line_status = inv_globals.G_TO_STATUS_CLOSED
5915: , quantity = quantity_delivered
5916: , quantity_detailed = quantity_delivered
5917: , secondary_quantity_detailed = SECONDARY_QUANTITY_DELIVERED
5918: , wms_process_flag = 1

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

6577: ,secondary_quantity_delivered = Decode(p_mmtt_temp_id,NULL,
6578: Nvl(secondary_quantity_delivered,0)+l_sec_quantity_delivered,quantity_delivered)
6579: , line_status = Decode(p_mmtt_temp_id,NULL,
6580: Decode((Nvl(quantity_delivered,0)+l_quantity_delivered),quantity,
6581: inv_globals.G_TO_STATUS_CLOSED,line_status),line_status)
6582: , wms_process_flag = 1
6583: WHERE line_id = l_mo_split_tb(1).line_id;
6584:
6585: -- R12

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

6648: SET quantity_delivered = Decode(p_mmtt_temp_id,NULL,quantity,quantity_delivered)
6649: -- OPMConvergence
6650: , secondary_quantity_delivered = Decode(p_mmtt_temp_id,NULL,secondary_quantity,secondary_quantity_delivered)
6651: -- OPMConvergence
6652: , line_status = Decode(p_mmtt_temp_id,NULL,inv_globals.g_to_status_closed,line_status)
6653: , wms_process_flag = 1
6654: WHERE line_id = l_mol_rec.line_id;
6655:
6656: -- OPMConvergence

Line 11194: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

11190: AND mtrl.line_status = 7
11191: AND mtrl.quantity-Nvl(mtrl.quantity_delivered,0) > 0
11192: AND exists (SELECT 1
11193: FROM mtl_txn_request_headers mtrh
11194: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
11195: AND mtrh.header_id = mtrl.header_id);
11196:
11197: TYPE mol_mmtt_ctnt_tb_tp IS TABLE OF c_mol_mmtt_ctnt_cur%ROWTYPE;
11198: l_mol_mmtt_ctnt_tb mol_mmtt_ctnt_tb_tp;