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_MATERIAL_STATUS_GRP dependencies on MTL_MATERIAL_STATUSES_VL

Line 1264: FROM mtl_material_statuses_vl

1260: /* Added IF condition for bug 10231569 */
1261: IF (l_status_id IS NOT NULL) THEN
1262:
1263: SELECT status_code INTO l_status_code
1264: FROM mtl_material_statuses_vl
1265: WHERE status_id = l_status_id ;
1266:
1267: IF (l_new_status_id is not null) then
1268: SELECT status_code INTO l_new_status_code

Line 1269: FROM mtl_material_statuses_vl

1265: WHERE status_id = l_status_id ;
1266:
1267: IF (l_new_status_id is not null) then
1268: SELECT status_code INTO l_new_status_code
1269: FROM mtl_material_statuses_vl
1270: WHERE status_id = l_new_status_id ;
1271: end if;
1272: if (g_debug = 1) then
1273: inv_trx_util_pub.TRACE('sub,'||p_sub_code||' l_status_id ' || l_status_id ||',status ' || l_status_code || 'pending status id is:'

Line 1590: FROM mtl_material_statuses_vl

1586: /* Added IF condition for bug 10231569 */
1587: IF (l_status_id IS NOT NULL) THEN
1588:
1589: SELECT status_code INTO l_status_code
1590: FROM mtl_material_statuses_vl
1591: WHERE status_id = l_status_id ;
1592:
1593: IF (l_new_status_id is not null) then
1594: SELECT status_code INTO l_new_status_code

Line 1595: FROM mtl_material_statuses_vl

1591: WHERE status_id = l_status_id ;
1592:
1593: IF (l_new_status_id is not null) then
1594: SELECT status_code INTO l_new_status_code
1595: FROM mtl_material_statuses_vl
1596: WHERE status_id = l_new_status_id ;
1597: end if;
1598: if (g_debug = 1) then
1599: inv_trx_util_pub.TRACE('sub, l_status_id ' || l_status_id ||',status ' || l_status_code || 'pending status id is:'

Line 1857: FROM mtl_material_statuses_vl

1853: /* Added IF condition for bug 10231569 */
1854: IF (l_status_id IS NOT NULL) THEN
1855:
1856: SELECT status_code INTO l_status_code
1857: FROM mtl_material_statuses_vl
1858: WHERE status_id = l_status_id ;
1859: IF (l_new_status_id is not null) then
1860: SELECT status_code INTO l_new_status_code
1861: FROM mtl_material_statuses_vl

Line 1861: FROM mtl_material_statuses_vl

1857: FROM mtl_material_statuses_vl
1858: WHERE status_id = l_status_id ;
1859: IF (l_new_status_id is not null) then
1860: SELECT status_code INTO l_new_status_code
1861: FROM mtl_material_statuses_vl
1862: WHERE status_id = l_new_status_id ;
1863: end if;
1864: if (g_debug = 1) then
1865: inv_trx_util_pub.TRACE('sub, l_status_id ' || l_status_id ||',status ' || l_status_code || 'pending status id is:'

Line 1969: FROM mtl_material_statuses_vl

1965: /* Added IF condition for bug 10231569 */
1966: IF (l_status_id IS NOT NULL) THEN
1967:
1968: SELECT status_code INTO l_status_code
1969: FROM mtl_material_statuses_vl
1970: WHERE status_id = l_status_id ;
1971:
1972: if (g_debug = 1) then
1973: inv_trx_util_pub.TRACE('ser, l_status_id ' || l_status_id ||',status ' || l_status_code || ',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);