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 349: g_add_locator_message wms_zone_locators_temp.MESSAGE%TYPE;

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

Line 361: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;

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

Line 442: DELETE wms_zone_locators_temp;

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

Line 466: 'INSERT INTO wms_zone_locators_temp(

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

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

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

Line 1003: || ' and inventory_location_id not in (select inventory_location_id from wms_zone_locators wzl, wms_zones_vl wz where

999:
1000:
1001: l_where_str :=
1002: l_where_str
1003: || ' and inventory_location_id not in (select inventory_location_id from wms_zone_locators wzl, wms_zones_vl wz where
1004: wz.zone_id=wzl.zone_id and wz.zone_type=''L'') ';
1005:
1006: end if;
1007:

Line 1034: || ' (select locator_id from wms_zone_locators_all_v

1030: 9
1031: );
1032: l_where_str :=
1033: l_where_str
1034: || ' (select locator_id from wms_zone_locators_all_v
1035: where zone_id = :cur_zone_id) ';
1036: DEBUG ('70 l_where_str is ' || l_where_str,
1037: ' add_locators_grid',
1038: 9

Line 1741: * wms_zone_locators_temp to wms_zone_locators. For every

1737: END update_wms_zones;
1738:
1739: /**
1740: * This procedure saves the records from
1741: * wms_zone_locators_temp to wms_zone_locators. For every
1742: * record at a given index in the table p_zoneloc_messages
1743: * table, we get the the corresponding rowid from the input
1744: * parameter table p_zoneloc_rowid_t for the same index.
1745: * If the value in p_zoneloc_messages_t is 0, the

Line 1759: p_zone_id IN wms_zone_locators.zone_id%TYPE

1755: Else do nothing.
1756: **/
1757: PROCEDURE save_sel_locators (
1758: p_zoneloc_rowid_t IN wms_zones_pvt.zoneloc_rowid_t,
1759: p_zone_id IN wms_zone_locators.zone_id%TYPE
1760: ) IS
1761:
1762: l_progress_indicator VARCHAR2(10) := '0';
1763: l_module_name VARCHAR2(20) := 'SAVE_SEL_LOCATORS';

Line 1780: DELETE FROM wms_zone_locators

1776:
1777: l_progress_indicator := '10';
1778:
1779: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1780: DELETE FROM wms_zone_locators
1781: WHERE ROWID IN (
1782: SELECT wzl.ROWID
1783: FROM wms_zone_locators wzl,
1784: wms_zone_locators_temp wzlt

Line 1783: FROM wms_zone_locators wzl,

1779: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1780: DELETE FROM wms_zone_locators
1781: WHERE ROWID IN (
1782: SELECT wzl.ROWID
1783: FROM wms_zone_locators wzl,
1784: wms_zone_locators_temp wzlt
1785: WHERE wzl.zone_id = p_zone_id
1786: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1787: AND wzlt.message_id = 1

Line 1784: wms_zone_locators_temp wzlt

1780: DELETE FROM wms_zone_locators
1781: WHERE ROWID IN (
1782: SELECT wzl.ROWID
1783: FROM wms_zone_locators wzl,
1784: wms_zone_locators_temp wzlt
1785: WHERE wzl.zone_id = p_zone_id
1786: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1787: AND wzlt.message_id = 1
1788: AND wzl.organization_id = wzlt.organization_id

Line 1802: INSERT INTO wms_zone_locators (

1798:
1799: l_progress_indicator := '20';
1800:
1801: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1802: INSERT INTO wms_zone_locators (
1803: organization_id
1804: , zone_id
1805: , inventory_location_id
1806: , subinventory_code

Line 1832: FROM wms_zone_locators_temp wzlt

1828: , fnd_global.user_id
1829: , SYSDATE
1830: , fnd_global.user_id
1831: , fnd_global.login_id
1832: FROM wms_zone_locators_temp wzlt
1833: WHERE wzlt.message_id = 1
1834: AND ROWID = p_zoneloc_rowid_t (i)
1835: AND NOT EXISTS (
1836: SELECT 1

Line 1837: FROM wms_zone_locators wzl

1833: WHERE wzlt.message_id = 1
1834: AND ROWID = p_zoneloc_rowid_t (i)
1835: AND NOT EXISTS (
1836: SELECT 1
1837: FROM wms_zone_locators wzl
1838: WHERE wzl.zone_id = p_zone_id
1839: AND wzl.organization_id = wzlt.organization_id
1840: AND wzl.subinventory_code = wzlt.subinventory_code
1841: AND wzl.entire_sub_flag = 'Y'

Line 1845: FROM wms_zone_locators wzl

1841: AND wzl.entire_sub_flag = 'Y'
1842: )
1843: AND NOT EXISTS (
1844: SELECT 1
1845: FROM wms_zone_locators wzl
1846: WHERE wzl.zone_id = p_zone_id
1847: AND wzl.organization_id = wzlt.organization_id
1848: AND wzl.subinventory_code = wzlt.subinventory_code
1849: AND NVL(wzl.entire_sub_flag,'N') = 'N'

Line 1863: DELETE FROM wms_zone_locators

1859:
1860: l_progress_indicator := '30';
1861:
1862: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1863: DELETE FROM wms_zone_locators
1864: WHERE ROWID IN (
1865: SELECT wzl.ROWID
1866: FROM wms_zone_locators wzl,
1867: wms_zone_locators_temp wzlt

Line 1866: FROM wms_zone_locators wzl,

1862: FORALL i IN p_zoneloc_rowid_t.FIRST .. p_zoneloc_rowid_t.LAST
1863: DELETE FROM wms_zone_locators
1864: WHERE ROWID IN (
1865: SELECT wzl.ROWID
1866: FROM wms_zone_locators wzl,
1867: wms_zone_locators_temp wzlt
1868: WHERE wzl.zone_id = p_zone_id
1869: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1870: AND wzlt.message_id = 2

Line 1867: wms_zone_locators_temp wzlt

1863: DELETE FROM wms_zone_locators
1864: WHERE ROWID IN (
1865: SELECT wzl.ROWID
1866: FROM wms_zone_locators wzl,
1867: wms_zone_locators_temp wzlt
1868: WHERE wzl.zone_id = p_zone_id
1869: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1870: AND wzlt.message_id = 2
1871: AND wzl.organization_id = wzlt.organization_id

Line 1892: p_zone_id IN wms_zone_locators.zone_id%TYPE,

1888:
1889: END save_sel_locators;
1890:
1891: PROCEDURE save_all_locators (
1892: p_zone_id IN wms_zone_locators.zone_id%TYPE,
1893: p_org_id IN wms_zone_locators.organization_id%TYPE
1894: )
1895: IS
1896: l_org_id NUMBER;

Line 1893: p_org_id IN wms_zone_locators.organization_id%TYPE

1889: END save_sel_locators;
1890:
1891: PROCEDURE save_all_locators (
1892: p_zone_id IN wms_zone_locators.zone_id%TYPE,
1893: p_org_id IN wms_zone_locators.organization_id%TYPE
1894: )
1895: IS
1896: l_org_id NUMBER;
1897: l_zone_id NUMBER;

Line 1910: INSERT INTO wms_zone_locators

1906: BEGIN
1907: DEBUG (' p_zone_id==> ' || p_zone_id, 'save_all_locators', 9);
1908: DEBUG (' p_org_id==> ' || p_org_id, 'save_all_locators', 9);
1909:
1910: INSERT INTO wms_zone_locators
1911: (organization_id, zone_id, inventory_location_id,
1912: subinventory_code, entire_sub_flag, last_update_date,
1913: last_updated_by, creation_date, created_by,
1914: last_update_login)

Line 1920: FROM wms_zone_locators_temp

1916: subinventory_code,
1917: DECODE (inventory_location_id, -999, 'Y', 'N'), SYSDATE,
1918: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1919: fnd_global.user_id
1920: FROM wms_zone_locators_temp
1921: WHERE MESSAGE_ID = 1 );
1922:
1923: DEBUG ('committing' || SQL%ROWCOUNT, 'save_all_locators', 9);
1924:

Line 1925: DELETE FROM wms_zone_locators

1921: WHERE MESSAGE_ID = 1 );
1922:
1923: DEBUG ('committing' || SQL%ROWCOUNT, 'save_all_locators', 9);
1924:
1925: DELETE FROM wms_zone_locators
1926: WHERE inventory_location_id =
1927: (SELECT inventory_location_id
1928: FROM wms_zone_locators_temp
1929: WHERE MESSAGE_id = 2)

Line 1928: FROM wms_zone_locators_temp

1924:
1925: DELETE FROM wms_zone_locators
1926: WHERE inventory_location_id =
1927: (SELECT inventory_location_id
1928: FROM wms_zone_locators_temp
1929: WHERE MESSAGE_id = 2)
1930: AND zone_id = p_zone_id;
1931:
1932: COMMIT;

Line 2507: DELETE wms_zone_locators

2503: END IF; /* debug > 0 */
2504:
2505: l_progress_indicator := '10';
2506:
2507: DELETE wms_zone_locators
2508: WHERE zone_id = p_zone_id
2509: AND organization_id = p_organization_id
2510: AND subinventory_code = p_subinventory_code
2511: AND NVL(p_entire_sub_flag, 'N') = 'Y';

Line 2519: INSERT INTO wms_zone_locators(

2515: END IF;
2516:
2517: l_progress_indicator := '20';
2518:
2519: INSERT INTO wms_zone_locators(
2520: organization_id
2521: , zone_id
2522: , inventory_location_id
2523: , subinventory_code

Line 2545: FROM wms_zone_locators

2541: , p_last_update_login
2542: FROM dual
2543: WHERE NOT EXISTS (
2544: SELECT 1
2545: FROM wms_zone_locators
2546: WHERE zone_id = p_zone_id
2547: AND organization_id = p_organization_id
2548: AND subinventory_code = p_subinventory_code
2549: AND entire_sub_flag = 'Y'

Line 2553: FROM wms_zone_locators

2549: AND entire_sub_flag = 'Y'
2550: )
2551: AND NOT EXISTS (
2552: SELECT 1
2553: FROM wms_zone_locators
2554: WHERE zone_id = p_zone_id
2555: AND organization_id = p_organization_id
2556: AND subinventory_code = p_subinventory_code
2557: AND NVL(entire_sub_flag,'N') = 'N'

Line 2791: DELETE wms_zone_locators

2787: END IF;
2788:
2789: l_progress_indicator := '10';
2790:
2791: DELETE wms_zone_locators
2792: WHERE zone_id = p_zone_id
2793: AND organization_id = p_organization_id
2794: AND subinventory_code = p_subinventory_code
2795: AND ( (p_entire_sub_flag = 'Y') OR (