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

Line 836: l_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE; -- Bug 13624825

832:
833: /* Bug 6918409 */
834: l_serial_controlled NUMBER:=0;
835: l_count NUMBER:=0;
836: l_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE; -- Bug 13624825
837: l_new_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE; -- Bug 13624825
838: l_moqd_status_id NUMBER; -- Bug 13984662
839:
840: BEGIN

Line 837: l_new_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE; -- Bug 13624825

833: /* Bug 6918409 */
834: l_serial_controlled NUMBER:=0;
835: l_count NUMBER:=0;
836: l_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE; -- Bug 13624825
837: l_new_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE; -- Bug 13624825
838: l_moqd_status_id NUMBER; -- Bug 13984662
839:
840: BEGIN
841: --INCONV kkillams

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

Line 3242: l_return_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE := NULL; --Bug 13624825

3238: l_lpn_context NUMBER;
3239: l_lpn_org_id NUMBER;
3240: l_def_org_status NUMBER;
3241: l_return_status_id NUMBER := NULL;
3242: l_return_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE := NULL; --Bug 13624825
3243: l_counter NUMBER := 0;
3244: l_inventory_item_id NUMBER;
3245: l_lot_number NUMBER;
3246: l_lpn_id NUMBER;

Line 3494: FROM mtl_material_statuses

3490: If (l_return_status_id IS NOT NULL AND l_return_status_id <> -1) THEN
3491: BEGIN
3492: SELECT status_code
3493: INTO l_return_status_code
3494: FROM mtl_material_statuses
3495: WHERE status_id =l_return_status_id ;
3496: EXCEPTION
3497: WHEN NO_DATA_FOUND THEN
3498: l_return_status_id := NULL; --as status_id is not found in mtl_material_statuses therefore returning NULL

Line 3498: l_return_status_id := NULL; --as status_id is not found in mtl_material_statuses therefore returning NULL

3494: FROM mtl_material_statuses
3495: WHERE status_id =l_return_status_id ;
3496: EXCEPTION
3497: WHEN NO_DATA_FOUND THEN
3498: l_return_status_id := NULL; --as status_id is not found in mtl_material_statuses therefore returning NULL
3499: l_return_status_code := NULL;
3500: END;
3501: ELSIF (NVL(l_return_status_id,-99) = -1)THEN
3502: l_return_status_code := FND_MESSAGE.get_string('WMS','WMS_LPN_STATUS_MIXED');