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_PROJECT dependencies on MTL_ITEM_LOCATIONS

Line 472: FROM mtl_item_locations

468:
469: if ( f_project_id IS NULL and fm_locator is not NULL) then
470: SELECT project_id
471: INTO f_project_id
472: FROM mtl_item_locations
473: WHERE inventory_location_id = fm_locator
474: AND organization_id = fm_org_id ;
475: end if;
476:

Line 482: FROM mtl_item_locations

478: if ( prj_cntrl_level = 2 AND prj_ref_enabled = 1 ) then
479: if ( fm_locator IS NOT NULL ) then
480: SELECT task_id
481: INTO f_task_id
482: FROM mtl_item_locations
483: WHERE NVL(project_id,-999) = NVL(f_project_id, -111)
484: AND inventory_location_id = fm_locator
485: AND organization_id = fm_org_id ;
486:

Line 497: FROM mtl_item_locations

493: if ( t_project_id IS NULL ) then
494: if ( to_locator IS NOT NULL ) then
495: SELECT project_id
496: INTO t_project_id
497: FROM mtl_item_locations
498: WHERE inventory_location_id = to_locator
499: AND organization_id = fm_org_id ;
500: end if;
501: end if;

Line 507: FROM mtl_item_locations

503: if ( t_task_id IS NULL AND t_project_id IS NOT NULL) then
504: if ( to_locator IS NOT NULL ) then
505: SELECT task_id
506: INTO t_task_id
507: FROM mtl_item_locations
508: WHERE inventory_location_id = to_locator
509: AND organization_id = fm_org_id ;
510: end if;
511:

Line 576: FROM mtl_item_locations

572: null;
573: Else
574: SELECT project_id
575: INTO t_project_id
576: FROM mtl_item_locations
577: WHERE inventory_location_id = to_locator
578: AND organization_id = to_org_id ;
579: End If;
580: end if;

Line 587: FROM mtl_item_locations

583: if ( t_task_id IS NULL AND t_project_id IS NOT NULL) then
584: if ( to_locator IS NOT NULL ) then
585: SELECT task_id
586: INTO t_task_id
587: FROM mtl_item_locations
588: WHERE inventory_location_id = to_locator
589: AND organization_id = to_org_id ;
590: end if;
591:

Line 1105: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn

1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102:
1103: SELECT mil.segment19, mil.segment20
1104: INTO l_project_id, l_task_id
1105: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn
1106: WHERE wlpn.lpn_id = p_lpn_id
1107: AND wlpn.organization_id = p_organization_id
1108: AND wlpn.organization_id = mil.organization_id
1109: AND wlpn.locator_id = mil.inventory_location_id;

Line 1376: * Query MTL_ITEM_LOCATIONS to fetch concatenated physical locator segments, project Id

1372:
1373: /* Function to fetch Physical Locator segments, project and task given locator and org
1374: * Processing Logic: Check if G_CONCATENATED_SEGMENTS is populated.
1375: * If yes then
1376: * Query MTL_ITEM_LOCATIONS to fetch concatenated physical locator segments, project Id
1377: * and Task Id for the passed locator Id/Org Id. Call get_project_number and get_task_number
1378: * to get Project Number and Task Number.
1379: * else
1380: * Use FND_FLEX_KEYVAL to fetch the Concatenated segment values, Project Id, Task Id,

Line 1421: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');

1417:
1418: IF G_CONCATENATED_SEGMENTS IS NOT NULL THEN
1419:
1420: IF (l_debug = 1) THEN
1421: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');
1422: END IF;
1423: --Build the string to fetch locator id, project Id and
1424: --task Id from MTL_ITEM_LOCATIONS
1425: l_loc_str := 'SELECT ' || G_CONCATENATED_SEGMENTS || ', ';

Line 1424: --task Id from MTL_ITEM_LOCATIONS

1420: IF (l_debug = 1) THEN
1421: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');
1422: END IF;
1423: --Build the string to fetch locator id, project Id and
1424: --task Id from MTL_ITEM_LOCATIONS
1425: l_loc_str := 'SELECT ' || G_CONCATENATED_SEGMENTS || ', ';
1426: l_loc_str := l_loc_str || 'PROJECT_ID, TASK_ID FROM MTL_ITEM_LOCATIONS ';
1427: l_loc_str := l_loc_str || 'WHERE INVENTORY_LOCATION_ID = :1 AND ORGANIZATION_ID = :2';
1428:

Line 1426: l_loc_str := l_loc_str || 'PROJECT_ID, TASK_ID FROM MTL_ITEM_LOCATIONS ';

1422: END IF;
1423: --Build the string to fetch locator id, project Id and
1424: --task Id from MTL_ITEM_LOCATIONS
1425: l_loc_str := 'SELECT ' || G_CONCATENATED_SEGMENTS || ', ';
1426: l_loc_str := l_loc_str || 'PROJECT_ID, TASK_ID FROM MTL_ITEM_LOCATIONS ';
1427: l_loc_str := l_loc_str || 'WHERE INVENTORY_LOCATION_ID = :1 AND ORGANIZATION_ID = :2';
1428:
1429: IF (l_debug = 1) THEN
1430: MYDEBUG('l_loc_str:' || l_loc_str);

Line 1805: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');

1801:
1802: IF G_LOC_CONC_QRY IS NOT NULL THEN
1803:
1804: IF (l_debug = 1) THEN
1805: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');
1806: END IF;
1807: --Build the string to fetch locator from MTL_ITEM_LOCATIONS
1808: l_loc_str := 'SELECT ' || G_LOC_CONC_QRY ;
1809: l_loc_str := l_loc_str || ' FROM MTL_ITEM_LOCATIONS ';

Line 1807: --Build the string to fetch locator from MTL_ITEM_LOCATIONS

1803:
1804: IF (l_debug = 1) THEN
1805: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');
1806: END IF;
1807: --Build the string to fetch locator from MTL_ITEM_LOCATIONS
1808: l_loc_str := 'SELECT ' || G_LOC_CONC_QRY ;
1809: l_loc_str := l_loc_str || ' FROM MTL_ITEM_LOCATIONS ';
1810: l_loc_str := l_loc_str || ' WHERE INVENTORY_LOCATION_ID = :1 AND ORGANIZATION_ID = :2';
1811:

Line 1809: l_loc_str := l_loc_str || ' FROM MTL_ITEM_LOCATIONS ';

1805: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');
1806: END IF;
1807: --Build the string to fetch locator from MTL_ITEM_LOCATIONS
1808: l_loc_str := 'SELECT ' || G_LOC_CONC_QRY ;
1809: l_loc_str := l_loc_str || ' FROM MTL_ITEM_LOCATIONS ';
1810: l_loc_str := l_loc_str || ' WHERE INVENTORY_LOCATION_ID = :1 AND ORGANIZATION_ID = :2';
1811:
1812: IF (l_debug = 1) THEN
1813: MYDEBUG('l_loc_str:' || l_loc_str);