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_KFV

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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