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 467: FROM mtl_item_locations

463:
464: if ( f_project_id IS NULL and fm_locator is not NULL) then
465: SELECT project_id
466: INTO f_project_id
467: FROM mtl_item_locations
468: WHERE inventory_location_id = fm_locator
469: AND organization_id = fm_org_id ;
470: end if;
471:

Line 477: FROM mtl_item_locations

473: if ( prj_cntrl_level = 2 AND prj_ref_enabled = 1 ) then
474: if ( fm_locator IS NOT NULL ) then
475: SELECT task_id
476: INTO f_task_id
477: FROM mtl_item_locations
478: WHERE NVL(project_id,-999) = NVL(f_project_id, -111)
479: AND inventory_location_id = fm_locator
480: AND organization_id = fm_org_id ;
481:

Line 492: FROM mtl_item_locations

488: if ( t_project_id IS NULL ) then
489: if ( to_locator IS NOT NULL ) then
490: SELECT project_id
491: INTO t_project_id
492: FROM mtl_item_locations
493: WHERE inventory_location_id = to_locator
494: AND organization_id = fm_org_id ;
495: end if;
496: end if;

Line 502: FROM mtl_item_locations

498: if ( t_task_id IS NULL AND t_project_id IS NOT NULL) then
499: if ( to_locator IS NOT NULL ) then
500: SELECT task_id
501: INTO t_task_id
502: FROM mtl_item_locations
503: WHERE inventory_location_id = to_locator
504: AND organization_id = fm_org_id ;
505: end if;
506:

Line 571: FROM mtl_item_locations

567: null;
568: Else
569: SELECT project_id
570: INTO t_project_id
571: FROM mtl_item_locations
572: WHERE inventory_location_id = to_locator
573: AND organization_id = to_org_id ;
574: End If;
575: end if;

Line 582: FROM mtl_item_locations

578: if ( t_task_id IS NULL AND t_project_id IS NOT NULL) then
579: if ( to_locator IS NOT NULL ) then
580: SELECT task_id
581: INTO t_task_id
582: FROM mtl_item_locations
583: WHERE inventory_location_id = to_locator
584: AND organization_id = to_org_id ;
585: end if;
586:

Line 1100: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn

1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: SELECT mil.segment19, mil.segment20
1099: INTO l_project_id, l_task_id
1100: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn
1101: WHERE wlpn.lpn_id = p_lpn_id
1102: AND wlpn.organization_id = p_organization_id
1103: AND wlpn.organization_id = mil.organization_id
1104: AND wlpn.locator_id = mil.inventory_location_id;

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

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

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

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

Line 1419: --task Id from MTL_ITEM_LOCATIONS

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

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

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

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

1771:
1772: IF G_LOC_CONC_QRY IS NOT NULL THEN
1773:
1774: IF (l_debug = 1) THEN
1775: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');
1776: END IF;
1777: --Build the string to fetch locator from MTL_ITEM_LOCATIONS
1778: l_loc_str := 'SELECT ' || G_LOC_CONC_QRY ;
1779: l_loc_str := l_loc_str || ' FROM MTL_ITEM_LOCATIONS ';

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

1773:
1774: IF (l_debug = 1) THEN
1775: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');
1776: END IF;
1777: --Build the string to fetch locator from MTL_ITEM_LOCATIONS
1778: l_loc_str := 'SELECT ' || G_LOC_CONC_QRY ;
1779: l_loc_str := l_loc_str || ' FROM MTL_ITEM_LOCATIONS ';
1780: l_loc_str := l_loc_str || ' WHERE INVENTORY_LOCATION_ID = :1 AND ORGANIZATION_ID = :2';
1781:

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

1775: MYDEBUG('Using MTL_ITEM_LOCATIONS to get locator, project and task info');
1776: END IF;
1777: --Build the string to fetch locator from MTL_ITEM_LOCATIONS
1778: l_loc_str := 'SELECT ' || G_LOC_CONC_QRY ;
1779: l_loc_str := l_loc_str || ' FROM MTL_ITEM_LOCATIONS ';
1780: l_loc_str := l_loc_str || ' WHERE INVENTORY_LOCATION_ID = :1 AND ORGANIZATION_ID = :2';
1781:
1782: IF (l_debug = 1) THEN
1783: MYDEBUG('l_loc_str:' || l_loc_str);