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.WMS_ZONES_PVT dependencies on WMS_ZONE_LOCATORS

Line 164: DELETE FROM wms_zone_locators_temp;

160: END IF;
161:
162: l_progress_indicator := '20';
163:
164: DELETE FROM wms_zone_locators_temp;
165:
166: IF l_debug > 0 THEN
167: DEBUG ('deleted from wms_zone_locators_temp ' || SQL%ROWCOUNT,
168: l_module_name,

Line 167: DEBUG ('deleted from wms_zone_locators_temp ' || SQL%ROWCOUNT,

163:
164: DELETE FROM wms_zone_locators_temp;
165:
166: IF l_debug > 0 THEN
167: DEBUG ('deleted from wms_zone_locators_temp ' || SQL%ROWCOUNT,
168: l_module_name,
169: 9
170: );
171: END IF;

Line 175: INSERT INTO wms_zone_locators_temp(

171: END IF;
172:
173: l_progress_indicator := '30';
174:
175: INSERT INTO wms_zone_locators_temp(
176: message
177: , message_id
178: , inventory_location_id
179: , locator_name

Line 223: FROM wms_zone_locators wzl,

219: -- Default value should be Storage..i.e 1
220: g_subinventory_types(1)
221: )
222: , p_org_id
223: FROM wms_zone_locators wzl,
224: mtl_item_locations_kfv milk,
225: mtl_secondary_inventories msi,
226: mtl_material_statuses mms1,
227: mtl_material_statuses mms2

Line 260: FROM wms_zone_locators wzl,

256: -- The default value should be Storage, i.e. 1
257: g_subinventory_types (1)
258: )
259: , p_org_id
260: FROM wms_zone_locators wzl,
261: mtl_secondary_inventories msi,
262: mtl_material_statuses mms
263: WHERE wzl.zone_id = p_zone_id
264: AND wzl.organization_id = p_org_id

Line 300: * inserts the locators into the table WMS_ZONE_LOCATORS_TEMP.

296: END populate_grid;
297:
298: /**
299: * Using the filter criteria given in the Add Locators form,
300: * inserts the locators into the table WMS_ZONE_LOCATORS_TEMP.
301: *
302: * @param p_fm_zone_id from_zone_id in the range. Will have a
303: * null value if the user doesnt choose a from_zone
304: * @param p_to_zone_id to_zone_id in the range. Can have a null

Line 348: g_add_locator_message wms_zone_locators_temp.MESSAGE%TYPE;

344: l_insert_str VARCHAR2 (2000);
345: l_select_str VARCHAR2 (2000);
346: l_from_str VARCHAR2 (2000);
347: l_where_str VARCHAR2 (2000);
348: g_add_locator_message wms_zone_locators_temp.MESSAGE%TYPE;
349: l_query_str VARCHAR2 (4000);
350: l_query_handle NUMBER;
351: l_query_count NUMBER;
352: l_progress VARCHAR2 (10) := '0';

Line 360: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;

356: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
357: l_progress_indicator VARCHAR2(10) := '0';
358:
359: -- Zone enhancement
360: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;
361: l_jtf_message_id VARCHAR2(4) := 'NULL';
362:
363: -- bug 3659062
364: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

Line 441: DELETE wms_zone_locators_temp;

437: l_jtf_message_id := '1';
438: l_jtf_message := wms_zones_pvt.g_add_locators_message;
439: ELSE
440: -- clear the temp table if OK was pressed in ADD or REMOVE mode
441: DELETE wms_zone_locators_temp;
442: END IF;
443:
444: l_progress_indicator := '20';
445:

Line 465: 'INSERT INTO wms_zone_locators_temp(

461: AND organization_id = p_organization_id;
462: END IF;
463:
464: l_insert_str :=
465: 'INSERT INTO wms_zone_locators_temp(
466: message,
467: message_id,
468: inventory_location_id,
469: locator_name,

Line 544: ' from wms_zone_locators_v wzlv, mtl_material_statuses mms1, mtl_material_statuses mms2';

540: || ''') , '||p_organization_id;
541: DEBUG ('40 l_select_str is ' || l_select_str, ' add_locators_grid',
542: 9);
543: l_from_str :=
544: ' from wms_zone_locators_v wzlv, mtl_material_statuses mms1, mtl_material_statuses mms2';
545: DEBUG ('l_from_str is ' || l_from_str, l_module_name, 9);
546: l_where_str :=
547: l_where_str
548: || ' where mms1.status_id(+) = wzlv.locator_status ';

Line 1017: || ' (select locator_id from wms_zone_locators_all_v

1013: 9
1014: );
1015: l_where_str :=
1016: l_where_str
1017: || ' (select locator_id from wms_zone_locators_all_v
1018: where zone_id = :cur_zone_id) ';
1019: DEBUG ('70 l_where_str is ' || l_where_str,
1020: ' add_locators_grid',
1021: 9

Line 1717: * wms_zone_locators_temp to wms_zone_locators. For every

1713: END update_wms_zones;
1714:
1715: /**
1716: * This procedure saves the records from
1717: * wms_zone_locators_temp to wms_zone_locators. For every
1718: * record at a given index in the table p_zoneloc_messages
1719: * table, we get the the corresponding rowid from the input
1720: * parameter table p_zoneloc_rowid_t for the same index.
1721: * If the value in p_zoneloc_messages_t is 0, the

Line 1735: p_zone_id IN wms_zone_locators.zone_id%TYPE

1731: Else do nothing.
1732: **/
1733: PROCEDURE save_sel_locators (
1734: p_zoneloc_rowid_t IN wms_zones_pvt.zoneloc_rowid_t,
1735: p_zone_id IN wms_zone_locators.zone_id%TYPE
1736: ) IS
1737:
1738: l_progress_indicator VARCHAR2(10) := '0';
1739: l_module_name VARCHAR2(20) := 'SAVE_SEL_LOCATORS';

Line 1756: DELETE FROM wms_zone_locators

1752:
1753: l_progress_indicator := '10';
1754:
1755: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1756: DELETE FROM wms_zone_locators
1757: WHERE ROWID IN (
1758: SELECT wzl.ROWID
1759: FROM wms_zone_locators wzl,
1760: wms_zone_locators_temp wzlt

Line 1759: FROM wms_zone_locators wzl,

1755: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1756: DELETE FROM wms_zone_locators
1757: WHERE ROWID IN (
1758: SELECT wzl.ROWID
1759: FROM wms_zone_locators wzl,
1760: wms_zone_locators_temp wzlt
1761: WHERE wzl.zone_id = p_zone_id
1762: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1763: AND wzlt.message_id = 1

Line 1760: wms_zone_locators_temp wzlt

1756: DELETE FROM wms_zone_locators
1757: WHERE ROWID IN (
1758: SELECT wzl.ROWID
1759: FROM wms_zone_locators wzl,
1760: wms_zone_locators_temp wzlt
1761: WHERE wzl.zone_id = p_zone_id
1762: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1763: AND wzlt.message_id = 1
1764: AND wzl.organization_id = wzlt.organization_id

Line 1778: INSERT INTO wms_zone_locators (

1774:
1775: l_progress_indicator := '20';
1776:
1777: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1778: INSERT INTO wms_zone_locators (
1779: organization_id
1780: , zone_id
1781: , inventory_location_id
1782: , subinventory_code

Line 1808: FROM wms_zone_locators_temp wzlt

1804: , fnd_global.user_id
1805: , SYSDATE
1806: , fnd_global.user_id
1807: , fnd_global.login_id
1808: FROM wms_zone_locators_temp wzlt
1809: WHERE wzlt.message_id = 1
1810: AND ROWID = p_zoneloc_rowid_t (i)
1811: AND NOT EXISTS (
1812: SELECT 1

Line 1813: FROM wms_zone_locators wzl

1809: WHERE wzlt.message_id = 1
1810: AND ROWID = p_zoneloc_rowid_t (i)
1811: AND NOT EXISTS (
1812: SELECT 1
1813: FROM wms_zone_locators wzl
1814: WHERE wzl.zone_id = p_zone_id
1815: AND wzl.organization_id = wzlt.organization_id
1816: AND wzl.subinventory_code = wzlt.subinventory_code
1817: AND wzl.entire_sub_flag = 'Y'

Line 1821: FROM wms_zone_locators wzl

1817: AND wzl.entire_sub_flag = 'Y'
1818: )
1819: AND NOT EXISTS (
1820: SELECT 1
1821: FROM wms_zone_locators wzl
1822: WHERE wzl.zone_id = p_zone_id
1823: AND wzl.organization_id = wzlt.organization_id
1824: AND wzl.subinventory_code = wzlt.subinventory_code
1825: AND NVL(wzl.entire_sub_flag,'N') = 'N'

Line 1839: DELETE FROM wms_zone_locators

1835:
1836: l_progress_indicator := '30';
1837:
1838: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1839: DELETE FROM wms_zone_locators
1840: WHERE ROWID IN (
1841: SELECT wzl.ROWID
1842: FROM wms_zone_locators wzl,
1843: wms_zone_locators_temp wzlt

Line 1842: FROM wms_zone_locators wzl,

1838: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1839: DELETE FROM wms_zone_locators
1840: WHERE ROWID IN (
1841: SELECT wzl.ROWID
1842: FROM wms_zone_locators wzl,
1843: wms_zone_locators_temp wzlt
1844: WHERE wzl.zone_id = p_zone_id
1845: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1846: AND wzlt.message_id = 2

Line 1843: wms_zone_locators_temp wzlt

1839: DELETE FROM wms_zone_locators
1840: WHERE ROWID IN (
1841: SELECT wzl.ROWID
1842: FROM wms_zone_locators wzl,
1843: wms_zone_locators_temp wzlt
1844: WHERE wzl.zone_id = p_zone_id
1845: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1846: AND wzlt.message_id = 2
1847: AND wzl.organization_id = wzlt.organization_id

Line 1868: p_zone_id IN wms_zone_locators.zone_id%TYPE,

1864:
1865: END save_sel_locators;
1866:
1867: PROCEDURE save_all_locators (
1868: p_zone_id IN wms_zone_locators.zone_id%TYPE,
1869: p_org_id IN wms_zone_locators.organization_id%TYPE
1870: )
1871: IS
1872: l_org_id NUMBER;

Line 1869: p_org_id IN wms_zone_locators.organization_id%TYPE

1865: END save_sel_locators;
1866:
1867: PROCEDURE save_all_locators (
1868: p_zone_id IN wms_zone_locators.zone_id%TYPE,
1869: p_org_id IN wms_zone_locators.organization_id%TYPE
1870: )
1871: IS
1872: l_org_id NUMBER;
1873: l_zone_id NUMBER;

Line 1886: INSERT INTO wms_zone_locators

1882: BEGIN
1883: DEBUG (' p_zone_id==> ' || p_zone_id, 'save_all_locators', 9);
1884: DEBUG (' p_org_id==> ' || p_org_id, 'save_all_locators', 9);
1885:
1886: INSERT INTO wms_zone_locators
1887: (organization_id, zone_id, inventory_location_id,
1888: subinventory_code, entire_sub_flag, last_update_date,
1889: last_updated_by, creation_date, created_by,
1890: last_update_login)

Line 1896: FROM wms_zone_locators_temp

1892: subinventory_code,
1893: DECODE (inventory_location_id, -999, 'Y', 'N'), SYSDATE,
1894: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1895: fnd_global.user_id
1896: FROM wms_zone_locators_temp
1897: WHERE MESSAGE_ID = 1 );
1898:
1899: DEBUG ('committing' || SQL%ROWCOUNT, 'save_all_locators', 9);
1900:

Line 1901: DELETE FROM wms_zone_locators

1897: WHERE MESSAGE_ID = 1 );
1898:
1899: DEBUG ('committing' || SQL%ROWCOUNT, 'save_all_locators', 9);
1900:
1901: DELETE FROM wms_zone_locators
1902: WHERE inventory_location_id =
1903: (SELECT inventory_location_id
1904: FROM wms_zone_locators_temp
1905: WHERE MESSAGE_id = 2)

Line 1904: FROM wms_zone_locators_temp

1900:
1901: DELETE FROM wms_zone_locators
1902: WHERE inventory_location_id =
1903: (SELECT inventory_location_id
1904: FROM wms_zone_locators_temp
1905: WHERE MESSAGE_id = 2)
1906: AND zone_id = p_zone_id;
1907:
1908: COMMIT;

Line 2480: DELETE wms_zone_locators

2476: END IF; /* debug > 0 */
2477:
2478: l_progress_indicator := '10';
2479:
2480: DELETE wms_zone_locators
2481: WHERE zone_id = p_zone_id
2482: AND organization_id = p_organization_id
2483: AND subinventory_code = p_subinventory_code
2484: AND NVL(p_entire_sub_flag, 'N') = 'Y';

Line 2492: INSERT INTO wms_zone_locators(

2488: END IF;
2489:
2490: l_progress_indicator := '20';
2491:
2492: INSERT INTO wms_zone_locators(
2493: organization_id
2494: , zone_id
2495: , inventory_location_id
2496: , subinventory_code

Line 2518: FROM wms_zone_locators

2514: , p_last_update_login
2515: FROM dual
2516: WHERE NOT EXISTS (
2517: SELECT 1
2518: FROM wms_zone_locators
2519: WHERE zone_id = p_zone_id
2520: AND organization_id = p_organization_id
2521: AND subinventory_code = p_subinventory_code
2522: AND entire_sub_flag = 'Y'

Line 2526: FROM wms_zone_locators

2522: AND entire_sub_flag = 'Y'
2523: )
2524: AND NOT EXISTS (
2525: SELECT 1
2526: FROM wms_zone_locators
2527: WHERE zone_id = p_zone_id
2528: AND organization_id = p_organization_id
2529: AND subinventory_code = p_subinventory_code
2530: AND NVL(entire_sub_flag,'N') = 'N'

Line 2764: DELETE wms_zone_locators

2760: END IF;
2761:
2762: l_progress_indicator := '10';
2763:
2764: DELETE wms_zone_locators
2765: WHERE zone_id = p_zone_id
2766: AND organization_id = p_organization_id
2767: AND subinventory_code = p_subinventory_code
2768: AND ( (p_entire_sub_flag = 'Y') OR (