APPS.WMS_ZONES_PVT dependencies on MTL_MATERIAL_STATUSES

Line 32: TYPE locator_status_table IS TABLE OF mtl_material_statuses.status_code%TYPE

28:
29: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE
30: INDEX BY BINARY_INTEGER;
31:
32: TYPE locator_status_table IS TABLE OF mtl_material_statuses.status_code%TYPE
33: INDEX BY BINARY_INTEGER;
34:
35: TYPE subinventory_status_table IS TABLE OF mtl_material_statuses.status_code%TYPE
36: INDEX BY BINARY_INTEGER;

Line 35: TYPE subinventory_status_table IS TABLE OF mtl_material_statuses.status_code%TYPE

31:
32: TYPE locator_status_table IS TABLE OF mtl_material_statuses.status_code%TYPE
33: INDEX BY BINARY_INTEGER;
34:
35: TYPE subinventory_status_table IS TABLE OF mtl_material_statuses.status_code%TYPE
36: INDEX BY BINARY_INTEGER;
37:
38: g_locator_types lookup_meaning_table;
39: g_subinventory_types lookup_meaning_table;

Line 50: FROM mtl_material_statuses

46:
47: CURSOR sel_status IS
48: SELECT status_id,
49: status_code
50: FROM mtl_material_statuses
51: WHERE locator_control = 1
52: AND enabled_flag = 1;
53:
54: BEGIN

Line 66: FROM mtl_material_statuses

62: PROCEDURE set_subinventory_status IS
63:
64: CURSOR sel_status IS
65: SELECT status_id, status_code
66: FROM mtl_material_statuses
67: WHERE zone_control = 1
68: AND enabled_flag = 1;
69:
70: BEGIN

Line 226: mtl_material_statuses mms1,

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
228: WHERE wzl.zone_id = p_zone_id
229: AND wzl.organization_id = p_org_id
230: AND NVL(wzl.entire_sub_flag,'N') = 'N'

Line 227: mtl_material_statuses mms2

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
228: WHERE wzl.zone_id = p_zone_id
229: AND wzl.organization_id = p_org_id
230: AND NVL(wzl.entire_sub_flag,'N') = 'N'
231: AND wzl.organization_id = msi.organization_id

Line 262: mtl_material_statuses mms

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
265: AND NVL(wzl.entire_sub_flag,'N') = 'Y'
266: AND wzl.organization_id = msi.organization_id

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 785: mtl_material_statuses mms1,mtl_material_statuses mms2 ';

781: DEBUG ('40 l_select_str is ' || l_select_str, ' add_locators_grid',
782: 9);
783: l_from_str :=
784: ' from mtl_item_locations_kfv milk, mtl_secondary_inventories msi,
785: mtl_material_statuses mms1,mtl_material_statuses mms2 ';
786: DEBUG ('10 l_from_str is ' || l_from_str, ' add_locators_grid', 9);
787: l_where_str := ' where 1=1 ';
788: DEBUG ('10 l_where_str is ' || l_where_str, ' add_locators_grid', 9);
789: l_where_str :=