APPS.INVKBCGN dependencies on MTL_ITEM_LOCATIONS

Line 434: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

430: v_success Number := 1;
431: v_report_id Number := NULL;
432: v_org_code VARCHAR2(3);
433: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
434: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
435:
436: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
437: Begin
438:

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

465: ' nvl(wip_line_id, -9999) = '||
466: ' nvl(:line_id,nvl(wip_line_id,-9999)) AND ' ||
467: ' kanban_plan_id = -1 AND ' ||
468: --' release_kanban_flag = 1 AND ' ||
469: ' locator_id in ( select inventory_location_id from mtl_item_locations ' ||
470: ' where ' || p_where_loc ||
471: ' and organization_id = :org_id) '||
472: ' for update of organization_id NOWAIT ';
473:

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

603: 'nvl(source_locator_id, -9999) = '||
604: 'nvl(:sourcing_loc_id,nvl(source_locator_id,-9999)) AND ' ||
605: 'nvl(wip_line_id, -9999) = '||
606: 'nvl(:line_id,nvl(wip_line_id,-9999)) AND ' ||
607: 'locator_id in ( select inventory_location_id from mtl_item_locations ' ||
608: 'where ' || p_where_loc ||
609: ' and organization_id = :org_id) AND ' ||
610: 'kanban_plan_id = -1';
611: -- and || 'release_kanban_flag = 1 '

Line 817: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

813: v_success Number := 1;
814: v_report_id Number := NULL;
815: v_org_code VARCHAR2(3);
816: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
817: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
818:
819: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
820: Begin
821: if ( (X_ITEM_LO IS NULL) AND (X_ITEM_HI IS NULL) ) then

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

1030: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1031: l_report_id number;
1032: l_org_code VARCHAR2(3) := Null;
1033: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1034: l_loc_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1035:
1036: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1037: BEGIN
1038: l_pull_seq_rec.pull_sequence_id := X_pull_sequence_id;

Line 1088: from mtl_item_locations_kfv

1084: kb_get_conc_segments(X_org_id, X_loc_id, l_loc_name);
1085: /*
1086: Select concatenated_segments
1087: into l_loc_name
1088: from mtl_item_locations_kfv
1089: where inventory_location_id = X_loc_id and
1090: organization_id = X_org_id;
1091: */
1092: end if;

Line 1483: from mtl_item_locations

1479: v_seg19_f := True;
1480: select distinct project_name into v_proj_name
1481: from mtl_project_v where
1482: project_id = ( select nvl(to_number(SEGMENT19), 0)
1483: from mtl_item_locations
1484: where inventory_location_id = X_loc_id and
1485: organization_id = X_org_id );
1486: exception
1487: when others then

Line 1496: from mtl_item_locations

1492: v_seg20_f := True;
1493: select distinct A.task_name into v_task_name
1494: from mtl_task_v A where
1495: A.task_id = (select nvl(to_number(SEGMENT20), 0)
1496: from mtl_item_locations
1497: where inventory_location_id = X_loc_id and
1498: organization_id = X_org_id ) AND
1499: A.project_id = (select nvl(to_number(SEGMENT19), A.project_id)
1500: from mtl_item_locations

Line 1500: from mtl_item_locations

1496: from mtl_item_locations
1497: where inventory_location_id = X_loc_id and
1498: organization_id = X_org_id ) AND
1499: A.project_id = (select nvl(to_number(SEGMENT19), A.project_id)
1500: from mtl_item_locations
1501: where inventory_location_id = X_loc_id and
1502: organization_id = X_org_id );
1503: exception
1504: when others then

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

1521: end Loop;
1522:
1523: if v_loc_str is not null then
1524: v_parse_str := 'select '||v_loc_str||
1525: ' from mtl_item_locations where inventory_location_id = :loc_id '||
1526: ' and organization_id = :org_id';
1527:
1528: dsql_cur := dbms_sql.open_cursor;
1529: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);