APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_SYSTEM_ITEMS

Line 393: FROM mtl_system_items

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

Line 401: FROM mtl_system_items

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

Line 709: FROM mtl_system_items_b msik, mtl_lot_numbers mln

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

Line 721: FROM mtl_system_items_b msik

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

Line 758: FROM mtl_system_items_b msik, mtl_lot_numbers mln

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

Line 770: FROM mtl_system_items_b msik

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

Line 808: FROM mtl_system_items_b msik, mtl_lot_numbers mln

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

Line 820: FROM mtl_system_items_b msik

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

Line 4093: FROM mtl_system_items

4089: SELECT primary_uom_code
4090: , DECODE (revision_qty_control_code, 1, 'FALSE', 'TRUE')
4091: INTO l_start_primary_uom
4092: , l_revision_control
4093: FROM mtl_system_items
4094: WHERE organization_id = l_organization_id
4095: AND inventory_item_id = l_inventory_item_id;
4096: EXCEPTION
4097: WHEN NO_DATA_FOUND

Line 4117: FROM mtl_system_items

4113: /*Added for OSFM support for Serialized Lot Items.*/
4114: BEGIN
4115: SELECT serial_number_control_code
4116: INTO l_serial_code
4117: FROM mtl_system_items
4118: WHERE organization_id = l_organization_id
4119: AND inventory_item_id = l_inventory_item_id;
4120: EXCEPTION
4121: WHEN OTHERS

Line 5024: FROM mtl_system_items

5020: SELECT shelf_life_code
5021: , shelf_life_days
5022: INTO l_shelf_life_code
5023: , l_shelf_life_days
5024: FROM mtl_system_items
5025: WHERE inventory_item_id = p_item_id
5026: AND organization_id = p_organization_id;
5027: EXCEPTION
5028: WHEN NO_DATA_FOUND