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_MWB_QUERY_MANAGER dependencies on MTL_LOT_NUMBERS

Line 1972: even if the origination_type in mtl_lot_numbers is null */

1968: or (nvl(g_item_id,-9999) <> nvl(rec.item_id, -9999))
1969: or (nvl(g_org_id,-9999) <> nvl(rec.org_id, -9999))
1970: ) then
1971: /* Bug 8396954. adding outerjoin condition for mfg_lookups table to get the records
1972: even if the origination_type in mtl_lot_numbers is null */
1973: UPDATE MTL_MWB_GTMP
1974: SET (
1975: ORIGINATION_TYPE
1976: , ORIGINATION_DATE

Line 1998: mtl_lot_numbers mln

1994: , mln.hold_date
1995: , mln.supplier_lot_number
1996: , mln.expiration_date
1997: FROM
1998: mtl_lot_numbers mln
1999: , mfg_lookups mfg
2000: WHERE lot_number = rec.lot
2001: AND mln.inventory_item_id = rec.item_id
2002: AND mln.organization_id = rec.org_id

Line 2018: FROM mtl_lot_numbers

2014: , LOT_EXPIRY_DATE
2015: ) = (
2016: SELECT grade_code
2017: , expiration_date
2018: FROM mtl_lot_numbers
2019: WHERE lot_number = rec.lot
2020: AND inventory_item_id = rec.item_id
2021: AND organization_id = rec.org_id
2022: )

Line 2678: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'ONHAND');

2674:
2675: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
2676: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
2677: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
2678: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'ONHAND');
2679: add_where_clause('moqd.lot_number = mln3.lot_number', 'ONHAND');
2680: add_where_clause('moqd.inventory_item_id = mln3.inventory_item_id', 'ONHAND'); -- Bug 9927569
2681: add_where_clause('moqd.organization_id = mln3.organization_id', 'ONHAND'); -- Bug 9927569
2682:

Line 2706: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');

2702: END IF;
2703: /* End of Bug 8396954 */
2704: --KMOTUPAL ME # 3922793
2705: IF (inv_mwb_globals.g_expired_lots = 'Y') THEN
2706: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');
2707: add_where_clause('moqd.lot_number = mln2.lot_number', 'ONHAND');
2708: add_where_clause('moqd.inventory_item_id = mln2.inventory_item_id', 'ONHAND');
2709: add_where_clause('moqd.organization_id = mln2.organization_id', 'ONHAND');
2710: add_where_clause('mln2.expiration_date <= :expiration_date', 'ONHAND');

Line 2718: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');

2714:
2715: --BUG 7556505
2716: IF (inv_mwb_globals.g_parent_lot IS NOT NULL) THEN
2717: IF (inv_mwb_globals.g_expired_lots <> 'Y') THEN
2718: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');
2719: add_where_clause('moqd.lot_number = mln2.lot_number', 'ONHAND');
2720: add_where_clause('moqd.inventory_item_id = mln2.inventory_item_id', 'ONHAND'); -- Bug 9927569
2721: add_where_clause('moqd.organization_id = mln2.organization_id', 'ONHAND'); -- Bug 9927569
2722: END IF;

Line 2745: add_from_clause('mtl_lot_numbers mln1', 'ONHAND');

2741: --bug # 6633612
2742:
2743: IF (inv_mwb_globals.g_grade_from_code IS NOT NULL) OR
2744: (inv_mwb_globals.g_lot_context IS NOT NULL) THEN
2745: add_from_clause('mtl_lot_numbers mln1', 'ONHAND');
2746: add_where_clause('moqd.lot_number = mln1.lot_number', 'ONHAND');
2747: add_where_clause('moqd.inventory_item_id = mln1.inventory_item_id', 'ONHAND');
2748: add_where_clause('moqd.organization_id = mln1.organization_id', 'ONHAND');
2749:

Line 2763: add_from_clause('mtl_lot_numbers mln', 'ONHAND');

2759:
2760: END IF; -- grade or lot context or lot attributes
2761:
2762: IF (inv_mwb_globals.g_lot_attr_query IS NOT NULL) THEN -- Bug 7566588 Changes Start
2763: add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2764: add_where_clause('moqd.lot_number = mln.lot_number', 'ONHAND');
2765: add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
2766: add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
2767: add_where_clause(inv_mwb_globals.g_lot_attr_query, 'ONHAND');

Line 2803: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

2799: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2800:
2801: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2802: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2803: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2804: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2805: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2806: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2807: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');

Line 2836: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

2832:
2833: IF inv_mwb_globals.g_status_id IS NOT NULL THEN
2834: if l_default_status_id is null then -- Onhand Material Status Support
2835: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2836: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2837: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2838: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2839: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2840: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');

Line 3004: add_from_clause('mtl_lot_numbers mln3', 'ONHAND');

3000:
3001: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
3002: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
3003: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
3004: add_from_clause('mtl_lot_numbers mln3', 'ONHAND');
3005: add_where_clause('msn.lot_number = mln3.lot_number', 'ONHAND');
3006: add_where_clause('msn.inventory_item_id = mln3.inventory_item_id', 'ONHAND'); -- Bug 9927569
3007: add_where_clause('msn.current_organization_id = mln3.organization_id', 'ONHAND'); -- Bug 9927569
3008:

Line 3031: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');

3027: END IF ;
3028: /* End of Bug 8396954 */
3029: --KMOTUPAL ME # 3922793
3030: IF (inv_mwb_globals.g_expired_lots = 'Y') THEN
3031: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');
3032: add_where_clause('msn.lot_number = mln2.lot_number', 'ONHAND');
3033: add_where_clause('msn.inventory_item_id = mln2.inventory_item_id', 'ONHAND');
3034: add_where_clause('msn.organization_id = mln2.organization_id', 'ONHAND');
3035: add_where_clause('mln2.expiration_date <= :expiration_date', 'ONHAND');

Line 3043: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');

3039:
3040: --BUG 7556505
3041: IF (inv_mwb_globals.g_parent_lot IS NOT NULL) THEN
3042: IF (inv_mwb_globals.g_expired_lots <> 'Y') THEN
3043: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');
3044: add_where_clause('msn.lot_number = mln2.lot_number', 'ONHAND'); -- 9927659
3045: add_where_clause('msn.inventory_item_id = mln2.inventory_item_id', 'ONHAND'); -- 9927569
3046: add_where_clause('msn.current_organization_id = mln2.organization_id', 'ONHAND'); -- 9927569
3047: END IF;

Line 3103: add_from_clause('mtl_lot_numbers mln', 'ONHAND');

3099: IF (inv_mwb_globals.g_grade_from_code IS NOT NULL
3100: OR inv_mwb_globals.g_lot_context IS NOT NULL
3101: OR inv_mwb_globals.g_lot_attr_query IS NOT NULL) -- Bug 7566588
3102: AND inv_mwb_globals.g_status_id IS NULL THEN
3103: add_from_clause('mtl_lot_numbers mln', 'ONHAND');
3104: add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
3105: add_where_clause('msn.inventory_item_id = mln.inventory_item_id', 'ONHAND');
3106: add_where_clause('msn.current_organization_id = mln.organization_id', 'ONHAND'); -- Bug 7566588
3107: END IF;

Line 3375: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', p_mat_loc);

3371:
3372: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
3373: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
3374: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
3375: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', p_mat_loc);
3376: add_where_clause('wlc.lot_number = mln3.lot_number',p_mat_loc);
3377: add_where_clause('wlc.inventory_item_id = mln3.inventory_item_id', p_mat_loc); -- Bug 9927569
3378: add_where_clause('wlc.organization_id = mln3.organization_id', p_mat_loc); -- Bug 9927569
3379:

Line 3547: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'RECEIVING');

3543:
3544: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
3545: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
3546: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
3547: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'RECEIVING');
3548: inv_mwb_query_manager.add_from_clause('rcv_lots_supply rls1','RECEIVING');
3549: add_where_clause('rls1.shipment_line_id(+) = rs.shipment_line_id', 'RECEIVING');
3550: add_where_clause('mln3.lot_number = rls1.lot_num', 'RECEIVING');
3551: add_where_clause('rs.item_id = mln3.inventory_item_id', 'RECEIVING'); -- Bug 9927569

Line 3804: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'RECEIVING');

3800:
3801: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
3802: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
3803: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
3804: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'RECEIVING');
3805: add_where_clause('msn.lot_number =mln3.lot_number', 'RECEIVING');
3806: add_where_clause('msn.inventory_item_id = mln3.inventory_item_id', 'RECEIVING'); -- Bug 9927569
3807: add_where_clause('msn.current_organization_id = mln3.organization_id', 'RECEIVING'); -- Bug 9927569
3808:

Line 3964: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'RECEIVING');

3960:
3961: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
3962: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
3963: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
3964: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'RECEIVING');
3965: add_where_clause('mln3.lot_number = rss.lot_num', 'RECEIVING');
3966: add_where_clause('rs.item_id = mln3.inventory_item_id', 'RECEIVING'); -- Bug 9927569
3967: add_where_clause('rs.to_organization_id = mln3.organization_id', 'RECEIVING'); -- Bug 9927569
3968:

Line 4193: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'INBOUND');

4189:
4190: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
4191: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
4192: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
4193: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'INBOUND');
4194: IF NOT ((inv_mwb_globals.g_lot_from IS NOT NULL
4195: OR inv_mwb_globals.g_lot_to IS NOT NULL)
4196: OR (inv_mwb_globals.g_tree_item_id IS NOT NULL
4197: AND l_lot_control = 2)) THEN

Line 4397: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'INBOUND');

4393:
4394: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
4395: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
4396: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
4397: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'INBOUND');
4398: IF NOT ((inv_mwb_globals.g_lot_from IS NOT NULL
4399: OR inv_mwb_globals.g_lot_to IS NOT NULL)
4400: OR (inv_mwb_globals.g_tree_item_id IS NOT NULL
4401: AND l_lot_control = 2)) THEN

Line 4573: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'INBOUND');

4569:
4570: /* Bug 8396954, Adding below if condition for checking supplier_lot_number condition */
4571: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR
4572: inv_mwb_globals.g_supplier_lot_to IS NOT NULL ) THEN
4573: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln3', 'INBOUND');
4574: IF NOT (inv_mwb_globals.g_lot_from IS NOT NULL
4575: OR inv_mwb_globals.g_lot_to IS NOT NULL
4576: OR (inv_mwb_globals.g_tree_item_id IS NOT NULL
4577: AND l_lot_control = 2)