APPS.INV_ITEM_INQ dependencies on MFG_LOOKUPS

Line 403: * a) Removed outer join between MFG_LOOKUPS and WMS_LICENSE_PLATE_NUMBERS since

399: Locator and Sub are fetched. (as part of bug 2314495)
400: ****************************************************************************/
401:
402: /* Changes for Bug #2810546
403: * a) Removed outer join between MFG_LOOKUPS and WMS_LICENSE_PLATE_NUMBERS since
404: * an LPN will always have a context associated
405: * b) Forked the code to fetch the dock door if the LPN context is "Loaded to Dock(9)"
406: * For this join between wms_license_plate_numbers, wms_shipping_transactions_temp
407: * and mtl_item_locations.

Line 489: mfg_lookups mlk

485: mtl_item_locations_kfv mlc ,
486: mtl_secondary_inventories msub,
487: mtl_item_locations_kfv milk,
488: mtl_system_items_vl msiv, /* Bug 5581528 */
489: mfg_lookups mlk
490: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
491: AND lpn.lpn_id = mmtt.transfer_lpn_id
492: AND lpn.organization_id = mp.organization_id
493: AND lpn.outermost_lpn_id = lpn3.lpn_id

Line 598: mfg_lookups mlk

594: mtl_secondary_inventories msub,
595: mtl_item_locations_kfv milk,
596: mtl_lot_numbers mln,
597: mtl_system_items_vl msiv, /* Bug 5581528 */
598: mfg_lookups mlk
599: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
600: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
601: AND lpn.lpn_id = mmtt.transfer_lpn_id
602: AND lpn.organization_id = mp.organization_id

Line 705: mfg_lookups mlk,

701: mtl_item_locations milk,
702: mtl_item_locations milk2,
703: mtl_lot_numbers mln,
704: mtl_system_items_vl msiv, /* Bug 5581528 */
705: mfg_lookups mlk,
706: wms_shipping_transaction_temp wstt
707: WHERE wlc.parent_lpn_id = p_parent_lpn_id
708: AND lpn.lpn_id = wlc.parent_lpn_id
709: AND lpn.organization_id = mp.organization_id

Line 768: mfg_lookups mlk,

764: cst_cost_groups ccg,
765: mtl_item_locations_kfv mlc ,
766: mtl_secondary_inventories msub,
767: mtl_item_locations_kfv milk,
768: mfg_lookups mlk,
769: wms_shipping_transaction_temp wstt,
770: mtl_item_locations_kfv milk2
771: WHERE wlc.parent_lpn_id = p_parent_lpn_id
772: AND lpn.lpn_id = wlc.parent_lpn_id

Line 874: mfg_lookups mlk

870: mtl_secondary_inventories msub,
871: mtl_item_locations milk,
872: mtl_lot_numbers mln,
873: mtl_system_items_vl msiv, /* Bug 5581528 */
874: mfg_lookups mlk
875: WHERE
876: lpn.lpn_id = wwlc.parent_lpn_id
877: AND lpn.organization_id = mp.organization_id
878: AND lpn.outermost_lpn_id = lpn3.lpn_id

Line 975: mfg_lookups mlk

971: cst_cost_groups ccg,
972: mtl_item_locations_kfv mlc ,
973: mtl_secondary_inventories msub,
974: mtl_item_locations_kfv milk,
975: mfg_lookups mlk
976: WHERE wlc.parent_lpn_id = p_parent_lpn_id
977: AND lpn.lpn_id = wlc.parent_lpn_id
978: AND lpn.organization_id = mp.organization_id
979: AND lpn.outermost_lpn_id = lpn3.lpn_id

Line 1063: , mfg_lookups mlk

1059: , cst_cost_groups ccg
1060: , mtl_item_locations mlc
1061: , mtl_secondary_inventories msub
1062: , mtl_lot_numbers mln
1063: , mfg_lookups mlk
1064:
1065: WHERE lpn.organization_id = p_organization_id
1066: AND wlc.inventory_item_id = p_inventory_item_id
1067: AND lpn.lpn_id = wlc.parent_lpn_id