APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_SYSTEM_ITEMS

Line 390: FROM mtl_system_items

386: SELECT lot_control_code
387: , serial_number_control_code
388: INTO l_st_lot_control_code
389: , l_st_serial_control_code
390: FROM mtl_system_items
391: WHERE inventory_item_id = p_st_item_id_tbl (1)
392: AND organization_id = p_st_org_id_tbl (1);
393:
394: SELECT lot_control_code

Line 398: FROM mtl_system_items

394: SELECT lot_control_code
395: , serial_number_control_code
396: INTO l_rs_lot_control_code
397: , l_rs_serial_control_code
398: FROM mtl_system_items
399: WHERE inventory_item_id = p_rs_item_id_tbl (1)
400: AND organization_id = p_rs_org_id_tbl (1);
401:
402: IF ( l_st_lot_control_code <> l_rs_lot_control_code

Line 706: FROM mtl_system_items_b msik, mtl_lot_numbers mln

702:
703: BEGIN
704: SELECT msik.lot_split_enabled
705: INTO l_validation_status
706: FROM mtl_system_items_b msik, mtl_lot_numbers mln
707: WHERE mln.organization_id = p_organization_id
708: AND mln.inventory_item_id = p_inventory_item_id
709: AND mln.lot_number = p_lot_number
710: AND mln.organization_id = msik.organization_id

Line 718: FROM mtl_system_items_b msik

714: THEN
715: BEGIN
716: SELECT msik.lot_split_enabled
717: INTO l_validation_status
718: FROM mtl_system_items_b msik
719: , mtl_transaction_lots_temp mtlt
720: , mtl_material_transactions_temp mmtt
721: WHERE mmtt.organization_id = p_organization_id
722: AND mmtt.inventory_item_id = p_inventory_item_id

Line 755: FROM mtl_system_items_b msik, mtl_lot_numbers mln

751:
752: BEGIN
753: SELECT msik.lot_merge_enabled
754: INTO l_validation_status
755: FROM mtl_system_items_b msik, mtl_lot_numbers mln
756: WHERE mln.organization_id = p_organization_id
757: AND mln.inventory_item_id = p_inventory_item_id
758: AND mln.lot_number = p_lot_number
759: AND mln.organization_id = msik.organization_id

Line 767: FROM mtl_system_items_b msik

763: THEN
764: BEGIN
765: SELECT msik.lot_merge_enabled
766: INTO l_validation_status
767: FROM mtl_system_items_b msik
768: , mtl_transaction_lots_temp mln
769: , mtl_material_transactions_temp mmtt
770: WHERE mmtt.organization_id = p_organization_id
771: AND mmtt.inventory_item_id = p_inventory_item_id

Line 805: FROM mtl_system_items_b msik, mtl_lot_numbers mln

801:
802: BEGIN
803: SELECT DECODE (msik.lot_control_code, 2, 'Y', 'N')
804: INTO l_validation_status
805: FROM mtl_system_items_b msik, mtl_lot_numbers mln
806: WHERE mln.organization_id = p_organization_id
807: AND mln.inventory_item_id = p_inventory_item_id
808: AND mln.lot_number = p_lot_number
809: AND mln.organization_id = msik.organization_id

Line 817: FROM mtl_system_items_b msik

813: THEN
814: BEGIN
815: SELECT DECODE (msik.lot_control_code, 2, 'Y', 'N')
816: INTO l_validation_status
817: FROM mtl_system_items_b msik
818: , mtl_transaction_lots_temp mln
819: , mtl_material_transactions_temp mmtt
820: WHERE mmtt.organization_id = p_organization_id
821: AND mmtt.inventory_item_id = p_inventory_item_id

Line 4134: FROM mtl_system_items

4130: SELECT primary_uom_code
4131: , DECODE (revision_qty_control_code, 1, 'FALSE', 'TRUE')
4132: INTO l_start_primary_uom
4133: , l_revision_control
4134: FROM mtl_system_items
4135: WHERE organization_id = l_organization_id
4136: AND inventory_item_id = l_inventory_item_id;
4137: EXCEPTION
4138: WHEN NO_DATA_FOUND

Line 4158: FROM mtl_system_items

4154: /*Added for OSFM support for Serialized Lot Items.*/
4155: BEGIN
4156: SELECT serial_number_control_code
4157: INTO l_serial_code
4158: FROM mtl_system_items
4159: WHERE organization_id = l_organization_id
4160: AND inventory_item_id = l_inventory_item_id;
4161: EXCEPTION
4162: WHEN OTHERS

Line 5053: FROM mtl_system_items

5049: SELECT shelf_life_code
5050: , shelf_life_days
5051: INTO l_shelf_life_code
5052: , l_shelf_life_days
5053: FROM mtl_system_items
5054: WHERE inventory_item_id = p_item_id
5055: AND organization_id = p_organization_id;
5056: EXCEPTION
5057: WHEN NO_DATA_FOUND