eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_SYSTEM_ITEMS_B

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