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