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 662: mtl_item_locations_kfv milk,

658: milk.description,
659: ml.meaning,
660: mil.picking_order
661: FROM
662: mtl_item_locations_kfv milk,
663: mtl_item_locations mil,
664: wms_license_plate_numbers wlpn,
665: mfg_lookups ml
666: WHERE milk.organization_id = p_org_id

Line 663: mtl_item_locations mil,

659: ml.meaning,
660: mil.picking_order
661: FROM
662: mtl_item_locations_kfv milk,
663: mtl_item_locations mil,
664: wms_license_plate_numbers wlpn,
665: mfg_lookups ml
666: WHERE milk.organization_id = p_org_id
667: AND milk.alias = p_alias

Line 694: mtl_item_locations_kfv milk,

690: milk.description,
691: ml.meaning,
692: mil.picking_order
693: FROM
694: mtl_item_locations_kfv milk,
695: mtl_item_locations mil,
696: wms_license_plate_numbers wlpn,
697: wsh_delivery_details wdd2,
698: wsh_delivery_assignments_v wda,

Line 695: mtl_item_locations mil,

691: ml.meaning,
692: mil.picking_order
693: FROM
694: mtl_item_locations_kfv milk,
695: mtl_item_locations mil,
696: wms_license_plate_numbers wlpn,
697: wsh_delivery_details wdd2,
698: wsh_delivery_assignments_v wda,
699: mfg_lookups ml

Line 750: mtl_item_locations_kfv milk,

746: milk.description,
747: ml.meaning,
748: mil.picking_order
749: FROM
750: mtl_item_locations_kfv milk,
751: mtl_item_locations mil,
752: wms_license_plate_numbers wlpn,
753: mfg_lookups ml
754: WHERE milk.organization_id = p_org_id

Line 751: mtl_item_locations mil,

747: ml.meaning,
748: mil.picking_order
749: FROM
750: mtl_item_locations_kfv milk,
751: mtl_item_locations mil,
752: wms_license_plate_numbers wlpn,
753: mfg_lookups ml
754: WHERE milk.organization_id = p_org_id
755: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc -- bug 2769126

Line 782: mtl_item_locations_kfv milk,

778: milk.description,
779: ml.meaning,
780: mil.picking_order
781: FROM
782: mtl_item_locations_kfv milk,
783: mtl_item_locations mil,
784: wms_license_plate_numbers wlpn,
785: wsh_delivery_details wdd2,
786: wsh_delivery_assignments_v wda,

Line 783: mtl_item_locations mil,

779: ml.meaning,
780: mil.picking_order
781: FROM
782: mtl_item_locations_kfv milk,
783: mtl_item_locations mil,
784: wms_license_plate_numbers wlpn,
785: wsh_delivery_details wdd2,
786: wsh_delivery_assignments_v wda,
787: mfg_lookups ml

Line 911: mtl_item_locations mil,

907: FROM
908: wsh_delivery_assignments_v wda,
909: wsh_delivery_details wdd,
910: wms_license_plate_numbers wlpn,
911: mtl_item_locations mil,
912: wms_license_plate_numbers wlpno
913: WHERE wlpn.organization_id = p_org_id
914: AND wlpn.lpn_context in ( 11,12)
915: AND wlpn.outermost_lpn_id = p_lpn_id

Line 983: mtl_item_locations mil

979: wms_license_plate_numbers wlpno,
980: wsh_delivery_assignments_v wda,
981: wsh_delivery_details wdd,
982: wsh_delivery_details wdd2,
983: mtl_item_locations mil
984: WHERE wlpn.outermost_lpn_id = p_lpn_id
985: AND wlpno.lpn_id = p_lpn_id -- bug 2764736
986: AND wlpn.lpn_context in ( 11, 12)
987: AND wlpn.organization_id = p_org_id

Line 1023: mtl_item_locations mil

1019: x_loc,
1020: x_project,
1021: x_task
1022: FROM wms_license_plate_numbers wlpn,
1023: mtl_item_locations mil
1024: WHERE wlpn.lpn_id = p_lpn_id
1025: AND wlpn.organization_id = p_org_id
1026: AND wlpn.locator_id = mil.inventory_location_id
1027: AND wlpn.organization_id = mil.organization_id

Line 1058: mtl_item_locations mil

1054: x_loc,
1055: x_project,
1056: x_task
1057: FROM wms_license_plate_numbers wlpn,
1058: mtl_item_locations mil
1059: WHERE wlpn.lpn_id = p_lpn_id
1060: AND wlpn.organization_id = p_org_id
1061: AND wlpn.locator_id = mil.inventory_location_id
1062: AND wlpn.organization_id = mil.organization_id

Line 1114: mtl_item_locations mil

1110: wms_license_plate_numbers wlpn,
1111: wms_license_plate_numbers wlpno,
1112: wsh_delivery_assignments_v wda,
1113: wsh_delivery_details wdd,
1114: mtl_item_locations mil
1115: WHERE wlpn.outermost_lpn_id = p_lpn_id
1116: AND wlpno.lpn_id = p_lpn_id -- bug 2764736
1117: AND wlpn.lpn_context in ( 11,12)
1118: AND wlpn.organization_id = p_org_id

Line 1218: mtl_item_locations_kfv milk

1214: SELECT DISTINCT
1215: wlpn.outermost_lpn_id
1216: FROM
1217: wms_license_plate_numbers wlpn,
1218: mtl_item_locations_kfv milk
1219: WHERE wlpn.lpn_context in (11,12)
1220: AND wlpn.subinventory_code = x_sub
1221: AND wlpn.organization_id = p_org_id
1222: AND milk.concatenated_segments LIKE (x_loc || '%')

Line 1479: FROM mtl_item_locations mil,

1475:
1476: SELECT COUNT(DISTINCT Nvl(mil.physical_location_id,
1477: mil.inventory_location_id))
1478: INTO x_tot_locs_for_del
1479: FROM mtl_item_locations mil,
1480: wsh_delivery_details wdd,
1481: wsh_delivery_assignments_v wda
1482: WHERE wda.delivery_id = x_delivery_id
1483: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1705: FROM mtl_item_locations mil

1701: IF p_transfer_lpn_id IS NULL OR p_transfer_lpn_id = 0 THEN
1702: BEGIN
1703: SELECT mil.inventory_location_type
1704: INTO l_to_loc_type
1705: FROM mtl_item_locations mil
1706: WHERE mil.organization_id = p_org_id
1707: AND mil.subinventory_code = p_to_sub
1708: AND mil.inventory_location_id = p_to_loc_id;
1709: IF (g_trace_on = 1) THEN mydebug('l_to_loc_type' || l_to_loc_type ); END IF;

Line 1919: mtl_item_locations mil

1915: msi.picking_order,
1916: msi.enable_locator_alias
1917: FROM
1918: mtl_secondary_inventories msi,
1919: mtl_item_locations mil
1920: WHERE msi.organization_id = p_org_id
1921: AND msi.lpn_controlled_flag = 1
1922: AND msi.secondary_inventory_name LIKE p_sub
1923: AND msi.secondary_inventory_name = mil.subinventory_code

Line 1980: mtl_item_locations_kfv milk,

1976: milk.description,
1977: ml.meaning,
1978: mil.picking_order
1979: FROM
1980: mtl_item_locations_kfv milk,
1981: mtl_item_locations mil,
1982: mfg_lookups ml,
1983: wms_license_plate_numbers wlpn
1984: WHERE milk.organization_id = p_org_id

Line 1981: mtl_item_locations mil,

1977: ml.meaning,
1978: mil.picking_order
1979: FROM
1980: mtl_item_locations_kfv milk,
1981: mtl_item_locations mil,
1982: mfg_lookups ml,
1983: wms_license_plate_numbers wlpn
1984: WHERE milk.organization_id = p_org_id
1985: AND milk.alias = p_alias

Line 2045: mtl_item_locations_kfv milk,

2041: milk.description,
2042: ml.meaning,
2043: mil.picking_order
2044: FROM
2045: mtl_item_locations_kfv milk,
2046: mtl_item_locations mil,
2047: mfg_lookups ml
2048: WHERE milk.organization_id = p_org_id
2049: AND milk.alias = p_alias

Line 2046: mtl_item_locations mil,

2042: ml.meaning,
2043: mil.picking_order
2044: FROM
2045: mtl_item_locations_kfv milk,
2046: mtl_item_locations mil,
2047: mfg_lookups ml
2048: WHERE milk.organization_id = p_org_id
2049: AND milk.alias = p_alias
2050: AND milk.subinventory_code = p_sub

Line 2114: mtl_item_locations_kfv milk,

2110: milk.description,
2111: ml.meaning,
2112: mil.picking_order
2113: FROM
2114: mtl_item_locations_kfv milk,
2115: mtl_item_locations mil,
2116: mfg_lookups ml,
2117: wms_license_plate_numbers wlpn
2118: WHERE milk.organization_id = p_org_id

Line 2115: mtl_item_locations mil,

2111: ml.meaning,
2112: mil.picking_order
2113: FROM
2114: mtl_item_locations_kfv milk,
2115: mtl_item_locations mil,
2116: mfg_lookups ml,
2117: wms_license_plate_numbers wlpn
2118: WHERE milk.organization_id = p_org_id
2119: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

Line 2179: mtl_item_locations_kfv milk,

2175: milk.description,
2176: ml.meaning,
2177: mil.picking_order
2178: FROM
2179: mtl_item_locations_kfv milk,
2180: mtl_item_locations mil,
2181: mfg_lookups ml
2182: WHERE milk.organization_id = p_org_id
2183: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

Line 2180: mtl_item_locations mil,

2176: ml.meaning,
2177: mil.picking_order
2178: FROM
2179: mtl_item_locations_kfv milk,
2180: mtl_item_locations mil,
2181: mfg_lookups ml
2182: WHERE milk.organization_id = p_org_id
2183: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc
2184: AND milk.subinventory_code = p_sub

Line 2244: mtl_item_locations_kfv milk

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

Line 2293: mtl_item_locations_kfv milk,

2289: milk.description,
2290: ml.meaning,
2291: mil.dropping_order
2292: FROM
2293: mtl_item_locations_kfv milk,
2294: mtl_item_locations mil,
2295: mfg_lookups ml
2296: WHERE milk.organization_id = p_org_id
2297: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

Line 2294: mtl_item_locations mil,

2290: ml.meaning,
2291: mil.dropping_order
2292: FROM
2293: mtl_item_locations_kfv milk,
2294: mtl_item_locations mil,
2295: mfg_lookups ml
2296: WHERE milk.organization_id = p_org_id
2297: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc
2298: AND milk.subinventory_code = p_sub

Line 2343: mtl_item_locations_kfv milk,

2339: milk.description,
2340: ml.meaning,
2341: mil.dropping_order
2342: FROM
2343: mtl_item_locations_kfv milk,
2344: mtl_item_locations mil,
2345: mfg_lookups ml
2346: WHERE milk.organization_id = p_org_id
2347: AND milk.alias = p_alias

Line 2344: mtl_item_locations mil,

2340: ml.meaning,
2341: mil.dropping_order
2342: FROM
2343: mtl_item_locations_kfv milk,
2344: mtl_item_locations mil,
2345: mfg_lookups ml
2346: WHERE milk.organization_id = p_org_id
2347: AND milk.alias = p_alias
2348: AND milk.subinventory_code = p_sub

Line 2383: mtl_item_locations_kfv milk,

2379: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2380: ml.meaning,
2381: mil.dropping_order
2382: FROM
2383: mtl_item_locations_kfv milk,
2384: mtl_item_locations mil,
2385: mfg_lookups ml
2386: WHERE milk.organization_id = p_org_id
2387: AND milk.subinventory_code = p_sub

Line 2384: mtl_item_locations mil,

2380: ml.meaning,
2381: mil.dropping_order
2382: FROM
2383: mtl_item_locations_kfv milk,
2384: mtl_item_locations mil,
2385: mfg_lookups ml
2386: WHERE milk.organization_id = p_org_id
2387: AND milk.subinventory_code = p_sub
2388: AND milk.inventory_location_id = mil.inventory_location_id