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.INVKBCGN dependencies on MTL_ITEM_LOCATIONS

Line 471: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

467: v_success Number := 1;
468: v_report_id Number := NULL;
469: v_org_code VARCHAR2(3);
470: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
471: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
472:
473: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
474: Begin
475:

Line 524: ' mkps.locator_id in ( select inventory_location_id from mtl_item_locations ' ||

520: ' nvl(mkps.wip_line_id, -9999) = '||
521: ' nvl(:line_id,nvl(mkps.wip_line_id,-9999)) AND ' ||
522: ' mkps.kanban_plan_id = -1 AND ' ||
523: --' mkps.release_kanban_flag = 1 AND ' ||
524: ' mkps.locator_id in ( select inventory_location_id from mtl_item_locations ' ||
525: ' where ' || p_where_loc ||
526: ' and organization_id = :org_id) '||
527: ' for update of mkps.organization_id NOWAIT ' ;
528: ELSE -- old kanban code

Line 553: ' locator_id in ( select inventory_location_id from mtl_item_locations ' ||

549: ' nvl(wip_line_id, -9999) = '||
550: ' nvl(:line_id,nvl(wip_line_id,-9999)) AND ' ||
551: ' kanban_plan_id = -1 AND ' ||
552: --' release_kanban_flag = 1 AND ' ||
553: ' locator_id in ( select inventory_location_id from mtl_item_locations ' ||
554: ' where ' || p_where_loc ||
555: ' and organization_id = :org_id) '||
556: ' for update of organization_id NOWAIT ';
557: END IF;

Line 711: 'mkps.locator_id in ( select inventory_location_id from mtl_item_locations ' ||

707: ' nvl(mkps.source_locator_id, -9999) = '||
708: ' nvl(:sourcing_loc_id,nvl(mkps.source_locator_id,-9999)) AND ' ||
709: ' nvl(mkps.wip_line_id, -9999) = '||
710: ' nvl(:line_id,nvl(mkps.wip_line_id,-9999)) AND ' ||
711: 'mkps.locator_id in ( select inventory_location_id from mtl_item_locations ' ||
712: 'where ' || p_where_loc ||
713: ' and organization_id = :org_id) AND ' ||
714: 'kanban_plan_id = -1';
715: -- and || 'release_kanban_flag = 1 '

Line 744: 'locator_id in ( select inventory_location_id from mtl_item_locations ' ||

740: 'nvl(source_locator_id, -9999) = '||
741: 'nvl(:sourcing_loc_id,nvl(source_locator_id,-9999)) AND ' ||
742: 'nvl(wip_line_id, -9999) = '||
743: 'nvl(:line_id,nvl(wip_line_id,-9999)) AND ' ||
744: 'locator_id in ( select inventory_location_id from mtl_item_locations ' ||
745: 'where ' || p_where_loc ||
746: ' and organization_id = :org_id) AND ' ||
747: 'kanban_plan_id = -1';
748: -- and || 'release_kanban_flag = 1 '

Line 1002: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

998: v_success Number := 1;
999: v_report_id Number := NULL;
1000: v_org_code VARCHAR2(3);
1001: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
1002: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
1003:
1004: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1005: Begin
1006: if ( (X_ITEM_LO IS NULL) AND (X_ITEM_HI IS NULL) ) then

Line 1297: l_loc_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;

1293: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1294: l_report_id number;
1295: l_org_code VARCHAR2(3) := Null;
1296: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1297: l_loc_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1298: --added for ekanban by javakat
1299: l_no_of_existing_cards NUMBER;
1300: l_no_of_activenhold_cards NUMBER;
1301: l_create_kanban BOOLEAN DEFAULT FALSE;

Line 1513: from mtl_item_locations_kfv

1509: kb_get_conc_segments(X_org_id, X_loc_id, l_loc_name);
1510: /*
1511: Select concatenated_segments
1512: into l_loc_name
1513: from mtl_item_locations_kfv
1514: where inventory_location_id = X_loc_id and
1515: organization_id = X_org_id;
1516: */
1517: end if;

Line 1936: from mtl_item_locations

1932: v_seg19_f := True;
1933: select distinct project_name into v_proj_name
1934: from mtl_project_v where
1935: project_id = ( select nvl(to_number(SEGMENT19), 0)
1936: from mtl_item_locations
1937: where inventory_location_id = X_loc_id and
1938: organization_id = X_org_id );
1939: exception
1940: when others then

Line 1949: from mtl_item_locations

1945: v_seg20_f := True;
1946: select distinct A.task_name into v_task_name
1947: from mtl_task_v A where
1948: A.task_id = (select nvl(to_number(SEGMENT20), 0)
1949: from mtl_item_locations
1950: where inventory_location_id = X_loc_id and
1951: organization_id = X_org_id ) AND
1952: A.project_id = (select nvl(to_number(SEGMENT19), A.project_id)
1953: from mtl_item_locations

Line 1953: from mtl_item_locations

1949: from mtl_item_locations
1950: where inventory_location_id = X_loc_id and
1951: organization_id = X_org_id ) AND
1952: A.project_id = (select nvl(to_number(SEGMENT19), A.project_id)
1953: from mtl_item_locations
1954: where inventory_location_id = X_loc_id and
1955: organization_id = X_org_id );
1956: exception
1957: when others then

Line 1978: ' from mtl_item_locations where inventory_location_id = :loc_id '||

1974: end Loop;
1975:
1976: if v_loc_str is not null then
1977: v_parse_str := 'select '||v_loc_str||
1978: ' from mtl_item_locations where inventory_location_id = :loc_id '||
1979: ' and organization_id = :org_id';
1980:
1981: dsql_cur := dbms_sql.open_cursor;
1982: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);

Line 2049: from mtl_item_locations_kfv

2045: if l_locator_id is not null Then
2046:
2047: Select concatenated_segments
2048: into x_loc_name
2049: from mtl_item_locations_kfv
2050: where inventory_location_id = l_locator_id
2051: and organization_id = l_organization_id;
2052:
2053: end if;