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_APIS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 702: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

698: , msik.description
699: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
700: , mms.status_code status_code
701: , mms.status_id
702: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
703: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
704: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
705: AND mln.organization_id = p_organization_id
706: AND mln.organization_id = msik.organization_id

Line 721: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

717: , msik.description
718: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
719: , NULL status_code
720: , msik.default_lot_status_id -- Bug#2267947
721: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
722: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
723: AND mln.organization_id = p_organization_id
724: AND mln.organization_id = msik.organization_id
725: AND mln.inventory_item_id = msik.inventory_item_id

Line 737: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

733: , msik.description
734: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
735: , mms.status_code status_code
736: , mms.status_id
737: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
738: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
739: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
740: AND mln.organization_id = p_organization_id
741: AND mln.organization_id = msik.organization_id

Line 756: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

752: , msik.description
753: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
754: , NULL status_code
755: , msik.default_lot_status_id -- Bug#2267947
756: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
757: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
758: AND mln.organization_id = p_organization_id
759: AND mln.organization_id = msik.organization_id
760: AND mln.inventory_item_id = msik.inventory_item_id

Line 777: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

773: , msik.description
774: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
775: , mms.status_code
776: , mms.status_id
777: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
778: WHERE moq.organization_id = p_organization_id
779: AND moq.lot_number IS NOT NULL
780: AND moq.organization_id = mil.organization_id
781: AND moq.organization_id = mln.organization_id

Line 806: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

802: , msik.description
803: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
804: , NULL status_code
805: , msik.default_lot_status_id -- Bug#2267947
806: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
807: WHERE moq.organization_id = p_organization_id
808: AND moq.lot_number IS NOT NULL
809: AND moq.organization_id = mil.organization_id
810: AND moq.organization_id = mln.organization_id

Line 836: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

832: , msik.description
833: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
834: , mms.status_code
835: , mms.status_id
836: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
837: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
838: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
839: AND mln.organization_id = p_organization_id
840: AND mln.organization_id = msik.organization_id

Line 855: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

851: , msik.description
852: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
853: , NULL status_code
854: , msik.default_lot_status_id -- Bug#2267947
855: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
856: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
857: AND mln.organization_id = p_organization_id
858: AND mln.organization_id = msik.organization_id
859: AND mln.inventory_item_id = msik.inventory_item_id

Line 876: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

872: , msik.description
873: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
874: , mms.status_code
875: , mms.status_id
876: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
877: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
878: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
879: AND mln.organization_id = p_organization_id
880: AND mln.organization_id = msik.organization_id

Line 895: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

891: , msik.description
892: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
893: , NULL status_code
894: , msik.default_lot_status_id -- Bug#2267947
895: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
896: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
897: AND mln.organization_id = p_organization_id
898: AND mln.organization_id = msik.organization_id
899: AND mln.inventory_item_id = msik.inventory_item_id