APPS.INV_UI_ITEM_LOVS dependencies on MTL_LOT_NUMBERS

Line 878: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */

874: NVL(msik.SECONDARY_DEFAULT_IND,''),
875: NVL(msik.TRACKING_QUANTITY_IND,'P'),
876: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
877: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
878: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */
879: WHERE msik.lot_split_enabled = 'Y'
880: AND msik.concatenated_segments LIKE (p_concatenated_segments||l_append)
881: AND msik.organization_id = mln.organization_id
882: AND msik.inventory_item_id = mln.inventory_item_id

Line 941: mtl_lot_numbers mln,

937: NVL(msik.TRACKING_QUANTITY_IND,'P'),
938: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
939: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
940: FROM mtl_system_items_vl msik, /* Bug 5581528 */
941: mtl_lot_numbers mln,
942: mtl_cross_references mcr
943: WHERE msik.lot_split_enabled = 'Y'
944: AND msik.organization_id = mln.organization_id
945: AND msik.inventory_item_id = mln.inventory_item_id

Line 1009: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */

1005: NVL(msik.SECONDARY_DEFAULT_IND,''),
1006: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1007: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1008: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1009: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */
1010: WHERE msik.lot_merge_enabled = 'Y'
1011: AND msik.concatenated_segments LIKE (p_concatenated_segments||l_append)
1012: AND msik.organization_id = mln.organization_id
1013: AND msik.inventory_item_id = mln.inventory_item_id

Line 1072: mtl_lot_numbers mln,

1068: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1069: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1070: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1071: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1072: mtl_lot_numbers mln,
1073: mtl_cross_references mcr
1074: WHERE msik.lot_merge_enabled = 'Y'
1075: AND msik.organization_id = mln.organization_id
1076: AND msik.inventory_item_id = mln.inventory_item_id

Line 1140: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */

1136: NVL(msik.SECONDARY_DEFAULT_IND,''),
1137: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1138: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1139: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1140: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */
1141: WHERE msik.concatenated_segments LIKE (p_concatenated_segments||l_append)
1142: AND msik.organization_id = mln.organization_id
1143: AND msik.inventory_item_id = mln.inventory_item_id
1144: AND mln.lot_number = p_lot_number

Line 1201: mtl_lot_numbers mln,

1197: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1198: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1199: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1200: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1201: mtl_lot_numbers mln,
1202: mtl_cross_references mcr
1203: WHERE msik.organization_id = mln.organization_id
1204: AND msik.inventory_item_id = mln.inventory_item_id
1205: AND mln.lot_number = p_lot_number

Line 1376: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */

1372: NVL(msik.SECONDARY_DEFAULT_IND,''),
1373: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1374: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1375: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1376: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */
1377: WHERE msik.concatenated_segments LIKE (p_concatenated_segments||l_append)
1378: AND msik.organization_id = mln.organization_id
1379: AND msik.inventory_item_id = mln.inventory_item_id
1380: AND mln.lot_number = p_lot_number

Line 1432: mtl_lot_numbers mln,

1428: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1429: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1430: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1431: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1432: mtl_lot_numbers mln,
1433: mtl_cross_references mcr
1434: WHERE msik.organization_id = mln.organization_id
1435: AND msik.inventory_item_id = mln.inventory_item_id
1436: AND mln.lot_number = p_lot_number