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 73: l_dflex_r.flexfield_name := 'MTL_ITEM_LOCATIONS';

69:
70: /* Populate the flex field record */
71:
72: l_dflex_r.application_id := 401;
73: l_dflex_r.flexfield_name := 'MTL_ITEM_LOCATIONS';
74: /* Get all contexts */
75: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
76:
77:

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

229: end if;
230: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL )
231: then
232: --DBMS_output.put_line('global segments > 0 or attrib cat is not null');
233: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_ITEM_LOCATIONS', values_or_ids => 'I'
234: , validation_date => SYSDATE) THEN
235:
236: --DBMS_output.put_line('Value set validation successful');
237:

Line 621: FROM mtl_item_locations_kfv

617:
618: BEGIN
619: SELECT concatenated_segments
620: INTO l_locator
621: FROM mtl_item_locations_kfv
622: WHERE organization_id = p_organization_id
623: AND alias = l_alias
624: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
625:

Line 644: FROM mtl_item_locations_kfv

640: BEGIN
641:
642: SELECT concatenated_segments
643: INTO l_locator
644: FROM mtl_item_locations_kfv
645: WHERE organization_id = p_organization_id
646: AND alias = l_alias
647: AND subinventory_code = p_subinventory_code
648: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;

Line 683: FROM mtl_item_locations_kfv

679: /*
680: BEGIN
681: SELECT inventory_location_id
682: INTO x_inventory_location_id
683: FROM mtl_item_locations_kfv
684: WHERE organization_id = l_organization_id
685: AND subinventory_code = p_subinventory_code
686: AND concatenated_segments = p_concatenated_segments
687: AND ROWNUM < 2;

Line 820: FROM mtl_item_locations_kfv

816: WHERE EXISTS( */
817:
818: SELECT subinventory_code
819: INTO l_subinventory_code
820: FROM mtl_item_locations_kfv
821: WHERE concatenated_segments = p_concatenated_segments
822: AND p_subinventory_code <> subinventory_code
823: AND organization_id = l_organization_id
824: AND ROWNUM = 1 ;

Line 919: FROM mtl_item_locations

915: WHERE organization_id= l_organization_id;
916:
917: SELECT segment20
918: INTO l_segment20
919: FROM mtl_item_locations
920: WHERE organization_id = l_organization_id
921: AND inventory_location_id = x_inventory_location_id;
922:
923: IF(l_project_reference_enabled = 'Y') THEN

Line 1028: UPDATE mtl_item_locations

1024:
1025: --DBMS_output.put_line('finished calling validate_loc_attr_info');
1026: --DBMS_output.put_line('updating MIL now ');
1027:
1028: UPDATE mtl_item_locations
1029: SET subinventory_code = NVL(p_subinventory_code, NULL)
1030: , status_id = NVL(l_status_id, NULL)
1031: , inventory_location_type = NVL(l_loc_type, NULL)
1032: , description = NVL(p_description, NULL)

Line 1385: FROM MTL_ITEM_LOCATIONS_KFV

1381:
1382: /* BEGIN
1383: SELECT inventory_location_id
1384: INTO l_inventory_location_id
1385: FROM MTL_ITEM_LOCATIONS_KFV
1386: WHERE concatenated_segments = p_concatenated_segments
1387: and organization_id = l_organization_id;
1388: END;
1389: */

Line 1439: FROM mtl_item_locations mil, mtl_secondary_inventories msi

1435: -- Retrieve the subinventory type for the sub that the locator is in.
1436: BEGIN
1437: SELECT NVL(msi.subinventory_type, 1)
1438: INTO l_subinventory_type
1439: FROM mtl_item_locations mil, mtl_secondary_inventories msi
1440: WHERE mil.inventory_location_id = l_inventory_location_id
1441: AND mil.organization_id = l_organization_id
1442: AND mil.subinventory_code = msi.secondary_inventory_name
1443: AND msi.organization_id = l_organization_id;

Line 1473: FROM mtl_item_locations

1469: SELECT status_id,
1470: subinventory_code
1471: INTO l_status_id,
1472: l_subinventory_code
1473: FROM mtl_item_locations
1474: WHERE inventory_location_id = l_inventory_location_id
1475: AND organization_id = l_organization_id;
1476:
1477: EXCEPTION

Line 1514: FROM mtl_item_locations_kfv

1510:
1511: BEGIN
1512: SELECT concatenated_segments
1513: INTO l_locator
1514: FROM mtl_item_locations_kfv
1515: WHERE organization_id = p_organization_id
1516: AND alias = l_alias
1517: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1518:

Line 1536: FROM mtl_item_locations_kfv

1532:
1533: BEGIN
1534: SELECT concatenated_segments
1535: INTO l_locator
1536: FROM mtl_item_locations_kfv
1537: WHERE organization_id = p_organization_id
1538: AND alias = l_alias
1539: AND subinventory_code = l_subinventory_code
1540: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;

Line 1804: We will update the MTL_ITEM_LOCATIONS

1800: END IF;
1801: /* End locator DFF attributes validation */
1802:
1803: /* When the control is at this point, data supplied are valid.
1804: We will update the MTL_ITEM_LOCATIONS
1805: table with the information provided
1806: */
1807:
1808: --DBMS_output.put_line('Before update ');

Line 1810: UPDATE mtl_item_locations

1806: */
1807:
1808: --DBMS_output.put_line('Before update ');
1809:
1810: UPDATE mtl_item_locations
1811: SET description = DECODE(p_description, fnd_api.g_miss_char, description, p_description)
1812: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)
1813: , inventory_location_type =
1814: DECODE(

Line 2065: FROM mtl_item_locations_kfv

2061: ELSE
2062: BEGIN
2063: SELECT inventory_location_id
2064: INTO l_locator_id
2065: FROM mtl_item_locations_kfv
2066: WHERE concatenated_segments = p_locator
2067: AND organization_id = l_organization_id;
2068: EXCEPTION
2069: WHEN NO_DATA_FOUND THEN

Line 2082: FROM mtl_item_locations

2078: /* Check if the locator and subinventory_code combination is valid */
2079: BEGIN
2080: SELECT 'VALID'
2081: INTO l_subflag
2082: FROM mtl_item_locations
2083: WHERE inventory_location_id = l_locator_id
2084: AND subinventory_code = p_subinventory_code
2085: AND organization_id = l_organization_id;
2086: EXCEPTION

Line 2319: Check if this inventory_location_id exists in MTL_ITEM_LOCATIONS.

2315: END IF;
2316: END IF;
2317:
2318: /* Check the validity of p_inventory_location_id is not null.
2319: Check if this inventory_location_id exists in MTL_ITEM_LOCATIONS.
2320: Validate if concatenated_segment passed is valid or not.
2321: If the concatenated segments is not null and If it is valid,fnd_flex_keyval.combination_id
2322: will return the inventory_location_id for the Concatenated_segment combination.
2323: Otherwise the concatenated_segment passed is not a valid one.

Line 2330: FROM mtl_item_locations

2326: SELECT 1
2327: INTO l_chk_loc
2328: FROM DUAL
2329: WHERE EXISTS(SELECT 1
2330: FROM mtl_item_locations
2331: WHERE inventory_location_id = p_inventory_location_id
2332: AND organization_id = l_organization_id);
2333:
2334: l_inventory_location_id := p_inventory_location_id;

Line 2375: FROM mtl_item_locations

2371: SELECT 1
2372: INTO l_physical_locator_id
2373: FROM DUAL
2374: WHERE EXISTS(SELECT 1
2375: FROM mtl_item_locations
2376: WHERE physical_location_id = l_inventory_location_id
2377: AND organization_id = l_organization_id
2378: AND inventory_location_id <> physical_location_id); --Bug :5036570
2379:

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

2387: NULL;
2388: END;
2389:
2390: /* Check if the locator is active or is it disabled:
2391: Check in MTL_ITEM_LOCATIONS -DISABLE_DATE > SYSDATE. if true then error
2392: */
2393:
2394: /* Replaced disable_date with nvl(disable_date,sysdate+1)
2395: as part of bug 2004798 in the sql below

Line 2400: FROM mtl_item_locations

2396: */
2397: BEGIN
2398: SELECT 1
2399: INTO l_active_loc
2400: FROM mtl_item_locations
2401: WHERE inventory_location_id = l_inventory_location_id
2402: AND organization_id = l_organization_id
2403: AND NVL(disable_date, SYSDATE + 1) > SYSDATE;
2404:

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

2413: END;
2414:
2415: /* Check the value of p_validation_req_flag
2416: If the value of p_validation_req_flag ='N' then
2417: delete the locator from MTL_ITEM_LOCATIONS table without validating further .
2418: Otherwise do the following steps */
2419: IF p_validation_req_flag = 'Y' THEN --If For Validation
2420: /* Check if the locator is present in MTL_ONHAND_QUANTITIES_DETAIL
2421: If the locator_id exists then error out*/

Line 2576: from MTL_ITEM_LOCATIONS

2572: END;
2573: END IF; --End If For Validation
2574:
2575: /* If all the above steps are success then delete the inventory_location_id
2576: from MTL_ITEM_LOCATIONS
2577: for the combination of inventory_location_id and organization_id*/
2578: DELETE mtl_item_locations
2579: WHERE inventory_location_id = l_inventory_location_id
2580: AND organization_id = l_organization_id;

Line 2578: DELETE mtl_item_locations

2574:
2575: /* If all the above steps are success then delete the inventory_location_id
2576: from MTL_ITEM_LOCATIONS
2577: for the combination of inventory_location_id and organization_id*/
2578: DELETE mtl_item_locations
2579: WHERE inventory_location_id = l_inventory_location_id
2580: AND organization_id = l_organization_id;
2581: EXCEPTION
2582: WHEN fnd_api.g_exc_error THEN