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 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