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_GMI_MIGRATION dependencies on MTL_MATERIAL_STATUSES_TL

Line 872: FROM mtl_material_statuses_tl

868: BEGIN
869: -- Check if the material status already exists in the discrete
870: SELECT count(*)
871: INTO l_count
872: FROM mtl_material_statuses_tl
873: WHERE
874: status_code = l_lot_status.lot_status and
875: rownum = 1;
876:

Line 882: FROM mtl_material_statuses_tl

878: /* Start for fix for Bug#9143261 */
879: UPDATE mtl_material_statuses_b -- 10413599
880: SET onhand_control = 1
881: WHERE status_id = (SELECT status_id
882: FROM mtl_material_statuses_tl
883: WHERE status_code = l_lot_status.lot_status
884: AND rownum = 1);
885: /* End for fix for Bug#9143261 */
886:

Line 891: FROM mtl_material_statuses_tl

887: /* Start for fix for Bug#10413599 */
888:
889: UPDATE ic_lots_sts
890: SET status_id = (SELECT status_id
891: FROM mtl_material_statuses_tl
892: WHERE status_code = l_lot_status.lot_status
893: AND rownum = 1),
894: migrated_ind = 1
895: WHERE lot_status = l_lot_status.lot_status;