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

Line 125: l_dflex_r.flexfield_name := 'MTL_ITEM_LOCATIONS';

121:
122: /* Populate the flex field record */
123:
124: l_dflex_r.application_id := 401;
125: l_dflex_r.flexfield_name := 'MTL_ITEM_LOCATIONS';
126: /* Get all contexts */
127: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
128:
129:

Line 285: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_ITEM_LOCATIONS', values_or_ids => 'I'

281: end if;
282: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL )
283: then
284: --DBMS_output.put_line('global segments > 0 or attrib cat is not null');
285: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_ITEM_LOCATIONS', values_or_ids => 'I'
286: , validation_date => SYSDATE) THEN
287:
288: --DBMS_output.put_line('Value set validation successful');
289:

Line 679: FROM mtl_item_locations_kfv

675:
676: BEGIN
677: SELECT concatenated_segments
678: INTO l_locator
679: FROM mtl_item_locations_kfv
680: WHERE organization_id = p_organization_id
681: AND alias = l_alias
682: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
683:

Line 702: FROM mtl_item_locations_kfv

698: BEGIN
699:
700: SELECT concatenated_segments
701: INTO l_locator
702: FROM mtl_item_locations_kfv
703: WHERE organization_id = p_organization_id
704: AND alias = l_alias
705: AND subinventory_code = p_subinventory_code
706: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;

Line 741: FROM mtl_item_locations_kfv

737: /*
738: BEGIN
739: SELECT inventory_location_id
740: INTO x_inventory_location_id
741: FROM mtl_item_locations_kfv
742: WHERE organization_id = l_organization_id
743: AND subinventory_code = p_subinventory_code
744: AND concatenated_segments = p_concatenated_segments
745: AND ROWNUM < 2;

Line 888: FROM mtl_item_locations_kfv

884: -- Bug 7581675
885:
886: SELECT subinventory_code
887: INTO l_subinventory_code
888: FROM mtl_item_locations_kfv
889: WHERE concatenated_segments like l_physical_concat_seg||'%' -- instead of p_concatenated_segments
890: AND p_subinventory_code <> subinventory_code
891: AND organization_id = l_organization_id
892: AND ROWNUM = 1 ;

Line 989: FROM mtl_item_locations

985: --Bug 8520814 Creation of locator should not faile with error Task Required when Project
986: --Passed is NULL
987: SELECT segment19,segment20
988: INTO l_segment19,l_segment20
989: FROM mtl_item_locations
990: WHERE organization_id = l_organization_id
991: AND inventory_location_id = x_inventory_location_id;
992:
993: IF(l_project_reference_enabled = 'Y') THEN

Line 1114: UPDATE mtl_item_locations

1110:
1111: --DBMS_output.put_line('finished calling validate_loc_attr_info');
1112: --DBMS_output.put_line('updating MIL now ');
1113:
1114: UPDATE mtl_item_locations
1115: SET subinventory_code = NVL(p_subinventory_code, NULL)
1116: , status_id = NVL(l_status_id, NULL)
1117: , inventory_location_type = NVL(l_loc_type, NULL)
1118: , description = NVL(p_description, NULL)

Line 1468: FROM MTL_ITEM_LOCATIONS_KFV

1464:
1465: /* BEGIN
1466: SELECT inventory_location_id
1467: INTO l_inventory_location_id
1468: FROM MTL_ITEM_LOCATIONS_KFV
1469: WHERE concatenated_segments = p_concatenated_segments
1470: and organization_id = l_organization_id;
1471: END;
1472: */

Line 1522: FROM mtl_item_locations mil, mtl_secondary_inventories msi

1518: -- Retrieve the subinventory type for the sub that the locator is in.
1519: BEGIN
1520: SELECT NVL(msi.subinventory_type, 1)
1521: INTO l_subinventory_type
1522: FROM mtl_item_locations mil, mtl_secondary_inventories msi
1523: WHERE mil.inventory_location_id = l_inventory_location_id
1524: AND mil.organization_id = l_organization_id
1525: AND mil.subinventory_code = msi.secondary_inventory_name
1526: AND msi.organization_id = l_organization_id;

Line 1556: FROM mtl_item_locations

1552: SELECT status_id,
1553: subinventory_code
1554: INTO l_status_id,
1555: l_subinventory_code
1556: FROM mtl_item_locations
1557: WHERE inventory_location_id = l_inventory_location_id
1558: AND organization_id = l_organization_id;
1559:
1560: EXCEPTION

Line 1597: FROM mtl_item_locations_kfv

1593:
1594: BEGIN
1595: SELECT concatenated_segments
1596: INTO l_locator
1597: FROM mtl_item_locations_kfv
1598: WHERE organization_id = p_organization_id
1599: AND alias = l_alias
1600: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1601:

Line 1619: FROM mtl_item_locations_kfv

1615:
1616: BEGIN
1617: SELECT concatenated_segments
1618: INTO l_locator
1619: FROM mtl_item_locations_kfv
1620: WHERE organization_id = p_organization_id
1621: AND alias = l_alias
1622: AND subinventory_code = l_subinventory_code
1623: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;

Line 1887: We will update the MTL_ITEM_LOCATIONS

1883: END IF;
1884: /* End locator DFF attributes validation */
1885:
1886: /* When the control is at this point, data supplied are valid.
1887: We will update the MTL_ITEM_LOCATIONS
1888: table with the information provided
1889: */
1890: --bug 7297065
1891: IF (p_disabled_date is not null ) THEN

Line 1906: UPDATE mtl_item_locations

1902: -- end of bug 7297065
1903:
1904: --DBMS_output.put_line('Before update ');
1905:
1906: UPDATE mtl_item_locations
1907: SET description = DECODE(p_description, fnd_api.g_miss_char, description, p_description)
1908: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)
1909: , inventory_location_type =
1910: DECODE(

Line 2161: FROM mtl_item_locations_kfv

2157: ELSE
2158: BEGIN
2159: SELECT inventory_location_id
2160: INTO l_locator_id
2161: FROM mtl_item_locations_kfv
2162: WHERE concatenated_segments = p_locator
2163: AND organization_id = l_organization_id;
2164: EXCEPTION
2165: WHEN NO_DATA_FOUND THEN

Line 2178: FROM mtl_item_locations

2174: /* Check if the locator and subinventory_code combination is valid */
2175: BEGIN
2176: SELECT 'VALID'
2177: INTO l_subflag
2178: FROM mtl_item_locations
2179: WHERE inventory_location_id = l_locator_id
2180: AND subinventory_code = p_subinventory_code
2181: AND organization_id = l_organization_id;
2182: EXCEPTION

Line 2415: Check if this inventory_location_id exists in MTL_ITEM_LOCATIONS.

2411: END IF;
2412: END IF;
2413:
2414: /* Check the validity of p_inventory_location_id is not null.
2415: Check if this inventory_location_id exists in MTL_ITEM_LOCATIONS.
2416: Validate if concatenated_segment passed is valid or not.
2417: If the concatenated segments is not null and If it is valid,fnd_flex_keyval.combination_id
2418: will return the inventory_location_id for the Concatenated_segment combination.
2419: Otherwise the concatenated_segment passed is not a valid one.

Line 2426: FROM mtl_item_locations

2422: SELECT 1
2423: INTO l_chk_loc
2424: FROM DUAL
2425: WHERE EXISTS(SELECT 1
2426: FROM mtl_item_locations
2427: WHERE inventory_location_id = p_inventory_location_id
2428: AND organization_id = l_organization_id);
2429:
2430: l_inventory_location_id := p_inventory_location_id;

Line 2471: FROM mtl_item_locations

2467: SELECT 1
2468: INTO l_physical_locator_id
2469: FROM DUAL
2470: WHERE EXISTS(SELECT 1
2471: FROM mtl_item_locations
2472: WHERE physical_location_id = l_inventory_location_id
2473: AND organization_id = l_organization_id
2474: AND inventory_location_id <> physical_location_id); --Bug :5036570
2475:

Line 2487: Check in MTL_ITEM_LOCATIONS -DISABLE_DATE > SYSDATE. if true then error

2483: NULL;
2484: END;
2485:
2486: /* Check if the locator is active or is it disabled:
2487: Check in MTL_ITEM_LOCATIONS -DISABLE_DATE > SYSDATE. if true then error
2488: */
2489:
2490: /* Replaced disable_date with nvl(disable_date,sysdate+1)
2491: as part of bug 2004798 in the sql below

Line 2496: FROM mtl_item_locations

2492: */
2493: BEGIN
2494: SELECT 1
2495: INTO l_active_loc
2496: FROM mtl_item_locations
2497: WHERE inventory_location_id = l_inventory_location_id
2498: AND organization_id = l_organization_id
2499: AND NVL(disable_date, SYSDATE + 1) > SYSDATE;
2500:

Line 2513: delete the locator from MTL_ITEM_LOCATIONS table without validating further .

2509: END;
2510:
2511: /* Check the value of p_validation_req_flag
2512: If the value of p_validation_req_flag ='N' then
2513: delete the locator from MTL_ITEM_LOCATIONS table without validating further .
2514: Otherwise do the following steps */
2515: IF p_validation_req_flag = 'Y' THEN --If For Validation
2516: /* Check if the locator is present in MTL_ONHAND_QUANTITIES_DETAIL
2517: If the locator_id exists then error out*/

Line 2672: from MTL_ITEM_LOCATIONS

2668: END;
2669: END IF; --End If For Validation
2670:
2671: /* If all the above steps are success then delete the inventory_location_id
2672: from MTL_ITEM_LOCATIONS
2673: for the combination of inventory_location_id and organization_id*/
2674: DELETE mtl_item_locations
2675: WHERE inventory_location_id = l_inventory_location_id
2676: AND organization_id = l_organization_id;

Line 2674: DELETE mtl_item_locations

2670:
2671: /* If all the above steps are success then delete the inventory_location_id
2672: from MTL_ITEM_LOCATIONS
2673: for the combination of inventory_location_id and organization_id*/
2674: DELETE mtl_item_locations
2675: WHERE inventory_location_id = l_inventory_location_id
2676: AND organization_id = l_organization_id;
2677: EXCEPTION
2678: WHEN fnd_api.g_exc_error THEN