DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_LOT_NUMBERS

Line 1895: mtl_lot_numbers mln

1891: , mln.hold_date
1892: , mln.supplier_lot_number
1893: , mln.expiration_date
1894: FROM
1895: mtl_lot_numbers mln
1896: , mfg_lookups mfg
1897: WHERE lot_number = rec.lot
1898: AND mln.inventory_item_id = rec.item_id
1899: AND mln.organization_id = rec.org_id

Line 1914: FROM mtl_lot_numbers

1910: , LOT_EXPIRY_DATE
1911: ) = (
1912: SELECT grade_code
1913: , expiration_date
1914: FROM mtl_lot_numbers
1915: WHERE lot_number = rec.lot
1916: AND inventory_item_id = rec.item_id
1917: AND organization_id = rec.org_id
1918: )

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

2359: END IF;
2360:
2361: --KMOTUPAL ME # 3922793
2362: IF (inv_mwb_globals.g_expired_lots = 'Y') THEN
2363: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');
2364: add_where_clause('moqd.lot_number = mln2.lot_number', 'ONHAND');
2365: add_where_clause('moqd.inventory_item_id = mln2.inventory_item_id', 'ONHAND');
2366: add_where_clause('moqd.organization_id = mln2.organization_id', 'ONHAND');
2367: add_where_clause('mln2.expiration_date <= :expiration_date', 'ONHAND');

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

2371:
2372: --BUG 7556505
2373: IF (inv_mwb_globals.g_parent_lot IS NOT NULL) THEN
2374: IF (inv_mwb_globals.g_expired_lots <> 'Y') THEN
2375: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');
2376: add_where_clause('moqd.lot_number = mln2.lot_number', 'ONHAND');
2377: END IF;
2378: add_where_clause('mln2.parent_lot_number = :parent_lot_number', 'ONHAND');
2379: add_bind_variable('parent_lot_number', inv_mwb_globals.g_parent_lot);

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

2396: --bug # 6633612
2397:
2398: IF (inv_mwb_globals.g_grade_from_code IS NOT NULL) OR
2399: (inv_mwb_globals.g_lot_context IS NOT NULL) THEN
2400: add_from_clause('mtl_lot_numbers mln1', 'ONHAND');
2401: add_where_clause('moqd.lot_number = mln1.lot_number', 'ONHAND');
2402: add_where_clause('moqd.inventory_item_id = mln1.inventory_item_id', 'ONHAND');
2403: add_where_clause('moqd.organization_id = mln1.organization_id', 'ONHAND');
2404:

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

2414:
2415: END IF; -- grade or lot context or lot attributes
2416:
2417: IF (inv_mwb_globals.g_lot_attr_query IS NOT NULL) THEN -- Bug 7566588 Changes Start
2418: add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2419: add_where_clause('moqd.lot_number = mln.lot_number', 'ONHAND');
2420: add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
2421: add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
2422: add_where_clause(inv_mwb_globals.g_lot_attr_query, 'ONHAND');

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

2454: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2455:
2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');

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

2487:
2488: IF inv_mwb_globals.g_status_id IS NOT NULL THEN
2489: if l_default_status_id is null then -- Onhand Material Status Support
2490: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');

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

2618: END IF;
2619:
2620: --KMOTUPAL ME # 3922793
2621: IF (inv_mwb_globals.g_expired_lots = 'Y') THEN
2622: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');
2623: add_where_clause('msn.lot_number = mln2.lot_number', 'ONHAND');
2624: add_where_clause('msn.inventory_item_id = mln2.inventory_item_id', 'ONHAND');
2625: add_where_clause('msn.organization_id = mln2.organization_id', 'ONHAND');
2626: add_where_clause('mln2.expiration_date <= :expiration_date', 'ONHAND');

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

2630:
2631: --BUG 7556505
2632: IF (inv_mwb_globals.g_parent_lot IS NOT NULL) THEN
2633: IF (inv_mwb_globals.g_expired_lots <> 'Y') THEN
2634: add_from_clause('mtl_lot_numbers mln2', 'ONHAND');
2635: END IF;
2636: add_where_clause('mln2.parent_lot_number = :parent_lot_number', 'ONHAND');
2637: add_bind_variable('parent_lot_number', inv_mwb_globals.g_parent_lot);
2638: END IF;

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

2680: IF (inv_mwb_globals.g_grade_from_code IS NOT NULL
2681: OR inv_mwb_globals.g_lot_context IS NOT NULL
2682: OR inv_mwb_globals.g_lot_attr_query IS NOT NULL) -- Bug 7566588
2683: AND inv_mwb_globals.g_status_id IS NULL THEN
2684: add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2685: add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
2686: add_where_clause('msn.inventory_item_id = mln.inventory_item_id', 'ONHAND');
2687: add_where_clause('msn.current_organization_id = mln.organization_id', 'ONHAND'); -- Bug 7566588
2688: END IF;