APPS.INV_UI_ITEM_LOVS dependencies on MTL_LOT_NUMBERS

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

766: NVL(msik.SECONDARY_DEFAULT_IND,''),
767: NVL(msik.TRACKING_QUANTITY_IND,'P'),
768: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
769: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
770: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */
771: WHERE msik.lot_split_enabled = 'Y'
772: AND msik.concatenated_segments LIKE (p_concatenated_segments)
773: AND msik.organization_id = mln.organization_id
774: AND msik.inventory_item_id = mln.inventory_item_id

Line 832: mtl_lot_numbers mln,

828: NVL(msik.TRACKING_QUANTITY_IND,'P'),
829: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
830: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
831: FROM mtl_system_items_vl msik, /* Bug 5581528 */
832: mtl_lot_numbers mln,
833: mtl_cross_references mcr
834: WHERE msik.lot_split_enabled = 'Y'
835: AND msik.organization_id = mln.organization_id
836: AND msik.inventory_item_id = mln.inventory_item_id

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

895: NVL(msik.SECONDARY_DEFAULT_IND,''),
896: NVL(msik.TRACKING_QUANTITY_IND,'P'),
897: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
898: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
899: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */
900: WHERE msik.lot_merge_enabled = 'Y'
901: AND msik.concatenated_segments LIKE (p_concatenated_segments)
902: AND msik.organization_id = mln.organization_id
903: AND msik.inventory_item_id = mln.inventory_item_id

Line 961: mtl_lot_numbers mln,

957: NVL(msik.TRACKING_QUANTITY_IND,'P'),
958: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
959: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
960: FROM mtl_system_items_vl msik, /* Bug 5581528 */
961: mtl_lot_numbers mln,
962: mtl_cross_references mcr
963: WHERE msik.lot_merge_enabled = 'Y'
964: AND msik.organization_id = mln.organization_id
965: AND msik.inventory_item_id = mln.inventory_item_id

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

1024: NVL(msik.SECONDARY_DEFAULT_IND,''),
1025: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1026: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1027: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1028: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */
1029: WHERE msik.concatenated_segments LIKE (p_concatenated_segments)
1030: AND msik.organization_id = mln.organization_id
1031: AND msik.inventory_item_id = mln.inventory_item_id
1032: AND mln.lot_number = p_lot_number

Line 1088: mtl_lot_numbers mln,

1084: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1085: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1086: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1087: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1088: mtl_lot_numbers mln,
1089: mtl_cross_references mcr
1090: WHERE msik.organization_id = mln.organization_id
1091: AND msik.inventory_item_id = mln.inventory_item_id
1092: AND mln.lot_number = p_lot_number

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

1256: NVL(msik.SECONDARY_DEFAULT_IND,''),
1257: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1258: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1259: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1260: FROM mtl_system_items_vl msik, mtl_lot_numbers mln /* Bug 5581528 */
1261: WHERE msik.concatenated_segments LIKE (p_concatenated_segments)
1262: AND msik.organization_id = mln.organization_id
1263: AND msik.inventory_item_id = mln.inventory_item_id
1264: AND mln.lot_number = p_lot_number

Line 1315: mtl_lot_numbers mln,

1311: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1312: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1313: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1314: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1315: mtl_lot_numbers mln,
1316: mtl_cross_references mcr
1317: WHERE msik.organization_id = mln.organization_id
1318: AND msik.inventory_item_id = mln.inventory_item_id
1319: AND mln.lot_number = p_lot_number