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_MATERIAL_STATUSES_VL

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