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

Line 34: mtl_item_locations mil

30: FROM
31: wms_license_plate_numbers wlpn,
32: wsh_delivery_details wdd,
33: wsh_delivery_assignments_v wda,
34: mtl_item_locations mil
35: WHERE wlpn.organization_id = p_org_id
36: AND wlpn.locator_id = mil.inventory_location_id
37: AND Nvl(mil.physical_location_id, mil.inventory_location_id) = p_loc_id
38: AND wlpn.subinventory_code = p_sub

Line 85: mtl_item_locations mil

81: SELECT COUNT(DISTINCT wlpn.outermost_lpn_id)
82: INTO x_total_no_of_lpns
83: FROM
84: wms_license_plate_numbers wlpn,
85: mtl_item_locations mil
86: WHERE wlpn.lpn_context in (11,12)
87: AND wlpn.organization_id = p_org_id
88: AND wlpn.subinventory_code = p_sub
89: AND wlpn.locator_id = mil.inventory_location_id

Line 162: mtl_item_locations_kfv milk,

158: mil.picking_order,
159: mil.dropping_order,
160: ml.meaning
161: FROM
162: mtl_item_locations_kfv milk,
163: mtl_item_locations mil,
164: wms_license_plate_numbers wlpn,
165: mfg_lookups ml
166: WHERE milk.organization_id = p_org_id

Line 163: mtl_item_locations mil,

159: mil.dropping_order,
160: ml.meaning
161: FROM
162: mtl_item_locations_kfv milk,
163: mtl_item_locations mil,
164: wms_license_plate_numbers wlpn,
165: mfg_lookups ml
166: WHERE milk.organization_id = p_org_id
167: AND milk.subinventory_code = p_sub

Line 191: mtl_item_locations_kfv milk,

187: mil.picking_order,
188: mil.dropping_order,
189: ml.meaning
190: FROM
191: mtl_item_locations_kfv milk,
192: mtl_item_locations mil,
193: wms_license_plate_numbers wlpn,
194: wsh_delivery_details wdd2,
195: wsh_delivery_assignments_v wda,

Line 192: mtl_item_locations mil,

188: mil.dropping_order,
189: ml.meaning
190: FROM
191: mtl_item_locations_kfv milk,
192: mtl_item_locations mil,
193: wms_license_plate_numbers wlpn,
194: wsh_delivery_details wdd2,
195: wsh_delivery_assignments_v wda,
196: mfg_lookups ml

Line 384: mtl_item_locations_kfv milk,

380: nvl(milk.inventory_location_type, 3),
381: mil.picking_order
382: FROM
383: wms_license_plate_numbers wlpn,
384: mtl_item_locations_kfv milk,
385: mtl_item_locations mil
386: WHERE wlpn.lpn_context in (11, 12)
387: AND wlpn.organization_id = p_org_id
388: AND wlpn.license_plate_number LIKE p_lpn

Line 385: mtl_item_locations mil

381: mil.picking_order
382: FROM
383: wms_license_plate_numbers wlpn,
384: mtl_item_locations_kfv milk,
385: mtl_item_locations mil
386: WHERE wlpn.lpn_context in (11, 12)
387: AND wlpn.organization_id = p_org_id
388: AND wlpn.license_plate_number LIKE p_lpn
389: AND wlpn.outermost_lpn_id = wlpn.lpn_id

Line 667: mtl_item_locations_kfv milk,

663: milk.description,
664: ml.meaning,
665: mil.picking_order
666: FROM
667: mtl_item_locations_kfv milk,
668: mtl_item_locations mil,
669: wms_license_plate_numbers wlpn,
670: mfg_lookups ml
671: WHERE milk.organization_id = p_org_id

Line 668: mtl_item_locations mil,

664: ml.meaning,
665: mil.picking_order
666: FROM
667: mtl_item_locations_kfv milk,
668: mtl_item_locations mil,
669: wms_license_plate_numbers wlpn,
670: mfg_lookups ml
671: WHERE milk.organization_id = p_org_id
672: AND milk.alias = p_alias

Line 699: mtl_item_locations_kfv milk,

695: milk.description,
696: ml.meaning,
697: mil.picking_order
698: FROM
699: mtl_item_locations_kfv milk,
700: mtl_item_locations mil,
701: wms_license_plate_numbers wlpn,
702: wsh_delivery_details wdd2,
703: wsh_delivery_assignments_v wda,

Line 700: mtl_item_locations mil,

696: ml.meaning,
697: mil.picking_order
698: FROM
699: mtl_item_locations_kfv milk,
700: mtl_item_locations mil,
701: wms_license_plate_numbers wlpn,
702: wsh_delivery_details wdd2,
703: wsh_delivery_assignments_v wda,
704: mfg_lookups ml

Line 755: mtl_item_locations_kfv milk,

751: milk.description,
752: ml.meaning,
753: mil.picking_order
754: FROM
755: mtl_item_locations_kfv milk,
756: mtl_item_locations mil,
757: wms_license_plate_numbers wlpn,
758: mfg_lookups ml
759: WHERE milk.organization_id = p_org_id

Line 756: mtl_item_locations mil,

752: ml.meaning,
753: mil.picking_order
754: FROM
755: mtl_item_locations_kfv milk,
756: mtl_item_locations mil,
757: wms_license_plate_numbers wlpn,
758: mfg_lookups ml
759: WHERE milk.organization_id = p_org_id
760: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc -- bug 2769126

Line 787: mtl_item_locations_kfv milk,

783: milk.description,
784: ml.meaning,
785: mil.picking_order
786: FROM
787: mtl_item_locations_kfv milk,
788: mtl_item_locations mil,
789: wms_license_plate_numbers wlpn,
790: wsh_delivery_details wdd2,
791: wsh_delivery_assignments_v wda,

Line 788: mtl_item_locations mil,

784: ml.meaning,
785: mil.picking_order
786: FROM
787: mtl_item_locations_kfv milk,
788: mtl_item_locations mil,
789: wms_license_plate_numbers wlpn,
790: wsh_delivery_details wdd2,
791: wsh_delivery_assignments_v wda,
792: mfg_lookups ml

Line 916: mtl_item_locations mil,

912: FROM
913: wsh_delivery_assignments_v wda,
914: wsh_delivery_details wdd,
915: wms_license_plate_numbers wlpn,
916: mtl_item_locations mil,
917: wms_license_plate_numbers wlpno
918: WHERE wlpn.organization_id = p_org_id
919: AND wlpn.lpn_context in ( 11,12)
920: AND wlpn.outermost_lpn_id = p_lpn_id

Line 988: mtl_item_locations mil

984: wms_license_plate_numbers wlpno,
985: wsh_delivery_assignments_v wda,
986: wsh_delivery_details wdd,
987: wsh_delivery_details wdd2,
988: mtl_item_locations mil
989: WHERE wlpn.outermost_lpn_id = p_lpn_id
990: AND wlpno.lpn_id = p_lpn_id -- bug 2764736
991: AND wlpn.lpn_context in ( 11, 12)
992: AND wlpn.organization_id = p_org_id

Line 1028: mtl_item_locations mil

1024: x_loc,
1025: x_project,
1026: x_task
1027: FROM wms_license_plate_numbers wlpn,
1028: mtl_item_locations mil
1029: WHERE wlpn.lpn_id = p_lpn_id
1030: AND wlpn.organization_id = p_org_id
1031: AND wlpn.locator_id = mil.inventory_location_id
1032: AND wlpn.organization_id = mil.organization_id

Line 1063: mtl_item_locations mil

1059: x_loc,
1060: x_project,
1061: x_task
1062: FROM wms_license_plate_numbers wlpn,
1063: mtl_item_locations mil
1064: WHERE wlpn.lpn_id = p_lpn_id
1065: AND wlpn.organization_id = p_org_id
1066: AND wlpn.locator_id = mil.inventory_location_id
1067: AND wlpn.organization_id = mil.organization_id

Line 1119: mtl_item_locations mil

1115: wms_license_plate_numbers wlpn,
1116: wms_license_plate_numbers wlpno,
1117: wsh_delivery_assignments_v wda,
1118: wsh_delivery_details wdd,
1119: mtl_item_locations mil
1120: WHERE wlpn.outermost_lpn_id = p_lpn_id
1121: AND wlpno.lpn_id = p_lpn_id -- bug 2764736
1122: AND wlpn.lpn_context in ( 11,12)
1123: AND wlpn.organization_id = p_org_id

Line 1223: mtl_item_locations_kfv milk

1219: SELECT DISTINCT
1220: wlpn.outermost_lpn_id
1221: FROM
1222: wms_license_plate_numbers wlpn,
1223: mtl_item_locations_kfv milk
1224: WHERE wlpn.lpn_context in (11,12)
1225: AND wlpn.subinventory_code = x_sub
1226: AND wlpn.organization_id = p_org_id
1227: AND milk.concatenated_segments LIKE (x_loc || '%')

Line 1484: FROM mtl_item_locations mil,

1480:
1481: SELECT COUNT(DISTINCT Nvl(mil.physical_location_id,
1482: mil.inventory_location_id))
1483: INTO x_tot_locs_for_del
1484: FROM mtl_item_locations mil,
1485: wsh_delivery_details wdd,
1486: wsh_delivery_assignments_v wda
1487: WHERE wda.delivery_id = x_delivery_id
1488: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1710: FROM mtl_item_locations mil

1706: IF p_transfer_lpn_id IS NULL OR p_transfer_lpn_id = 0 THEN
1707: BEGIN
1708: SELECT mil.inventory_location_type
1709: INTO l_to_loc_type
1710: FROM mtl_item_locations mil
1711: WHERE mil.organization_id = p_org_id
1712: AND mil.subinventory_code = p_to_sub
1713: AND mil.inventory_location_id = p_to_loc_id;
1714: IF (g_trace_on = 1) THEN mydebug('l_to_loc_type' || l_to_loc_type ); END IF;

Line 1924: mtl_item_locations mil

1920: msi.picking_order,
1921: msi.enable_locator_alias
1922: FROM
1923: mtl_secondary_inventories msi,
1924: mtl_item_locations mil
1925: WHERE msi.organization_id = p_org_id
1926: AND msi.lpn_controlled_flag = 1
1927: AND msi.secondary_inventory_name LIKE p_sub
1928: AND msi.secondary_inventory_name = mil.subinventory_code

Line 1985: mtl_item_locations_kfv milk,

1981: milk.description,
1982: ml.meaning,
1983: mil.picking_order
1984: FROM
1985: mtl_item_locations_kfv milk,
1986: mtl_item_locations mil,
1987: mfg_lookups ml,
1988: wms_license_plate_numbers wlpn
1989: WHERE milk.organization_id = p_org_id

Line 1986: mtl_item_locations mil,

1982: ml.meaning,
1983: mil.picking_order
1984: FROM
1985: mtl_item_locations_kfv milk,
1986: mtl_item_locations mil,
1987: mfg_lookups ml,
1988: wms_license_plate_numbers wlpn
1989: WHERE milk.organization_id = p_org_id
1990: AND milk.alias = p_alias

Line 2050: mtl_item_locations_kfv milk,

2046: milk.description,
2047: ml.meaning,
2048: mil.picking_order
2049: FROM
2050: mtl_item_locations_kfv milk,
2051: mtl_item_locations mil,
2052: mfg_lookups ml
2053: WHERE milk.organization_id = p_org_id
2054: AND milk.alias = p_alias

Line 2051: mtl_item_locations mil,

2047: ml.meaning,
2048: mil.picking_order
2049: FROM
2050: mtl_item_locations_kfv milk,
2051: mtl_item_locations mil,
2052: mfg_lookups ml
2053: WHERE milk.organization_id = p_org_id
2054: AND milk.alias = p_alias
2055: AND milk.subinventory_code = p_sub

Line 2119: mtl_item_locations_kfv milk,

2115: milk.description,
2116: ml.meaning,
2117: mil.picking_order
2118: FROM
2119: mtl_item_locations_kfv milk,
2120: mtl_item_locations mil,
2121: mfg_lookups ml,
2122: wms_license_plate_numbers wlpn
2123: WHERE milk.organization_id = p_org_id

Line 2120: mtl_item_locations mil,

2116: ml.meaning,
2117: mil.picking_order
2118: FROM
2119: mtl_item_locations_kfv milk,
2120: mtl_item_locations mil,
2121: mfg_lookups ml,
2122: wms_license_plate_numbers wlpn
2123: WHERE milk.organization_id = p_org_id
2124: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

Line 2184: mtl_item_locations_kfv milk,

2180: milk.description,
2181: ml.meaning,
2182: mil.picking_order
2183: FROM
2184: mtl_item_locations_kfv milk,
2185: mtl_item_locations mil,
2186: mfg_lookups ml
2187: WHERE milk.organization_id = p_org_id
2188: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

Line 2185: mtl_item_locations mil,

2181: ml.meaning,
2182: mil.picking_order
2183: FROM
2184: mtl_item_locations_kfv milk,
2185: mtl_item_locations mil,
2186: mfg_lookups ml
2187: WHERE milk.organization_id = p_org_id
2188: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc
2189: AND milk.subinventory_code = p_sub

Line 2249: mtl_item_locations_kfv milk

2245: milk.subinventory_code,
2246: 11 lpn_context
2247: FROM
2248: wms_license_plate_numbers wlpn,
2249: mtl_item_locations_kfv milk
2250: WHERE wlpn.license_plate_number LIKE p_lpn
2251: AND wlpn.locator_id <> p_from_loc_id -- Make sure that we don't choose the TO lpn FROM the FROM locator
2252: AND milk.organization_id = p_org_id
2253: AND milk.project_id IS NULL

Line 2298: mtl_item_locations_kfv milk,

2294: milk.description,
2295: ml.meaning,
2296: mil.dropping_order
2297: FROM
2298: mtl_item_locations_kfv milk,
2299: mtl_item_locations mil,
2300: mfg_lookups ml
2301: WHERE milk.organization_id = p_org_id
2302: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

Line 2299: mtl_item_locations mil,

2295: ml.meaning,
2296: mil.dropping_order
2297: FROM
2298: mtl_item_locations_kfv milk,
2299: mtl_item_locations mil,
2300: mfg_lookups ml
2301: WHERE milk.organization_id = p_org_id
2302: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc
2303: AND milk.subinventory_code = p_sub

Line 2348: mtl_item_locations_kfv milk,

2344: milk.description,
2345: ml.meaning,
2346: mil.dropping_order
2347: FROM
2348: mtl_item_locations_kfv milk,
2349: mtl_item_locations mil,
2350: mfg_lookups ml
2351: WHERE milk.organization_id = p_org_id
2352: AND milk.alias = p_alias

Line 2349: mtl_item_locations mil,

2345: ml.meaning,
2346: mil.dropping_order
2347: FROM
2348: mtl_item_locations_kfv milk,
2349: mtl_item_locations mil,
2350: mfg_lookups ml
2351: WHERE milk.organization_id = p_org_id
2352: AND milk.alias = p_alias
2353: AND milk.subinventory_code = p_sub

Line 2388: mtl_item_locations_kfv milk,

2384: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2385: ml.meaning,
2386: mil.dropping_order
2387: FROM
2388: mtl_item_locations_kfv milk,
2389: mtl_item_locations mil,
2390: mfg_lookups ml
2391: WHERE milk.organization_id = p_org_id
2392: AND milk.subinventory_code = p_sub

Line 2389: mtl_item_locations mil,

2385: ml.meaning,
2386: mil.dropping_order
2387: FROM
2388: mtl_item_locations_kfv milk,
2389: mtl_item_locations mil,
2390: mfg_lookups ml
2391: WHERE milk.organization_id = p_org_id
2392: AND milk.subinventory_code = p_sub
2393: AND milk.inventory_location_id = mil.inventory_location_id