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 MFG_LOOKUPS

Line 147: l_type_meaning mfg_lookups.meaning%TYPE;

143: * Changed the datatype to the type of the associated column.
144: * VARCHAR2(30) was not eanough to hold the 'meaning' column under
145: * translated environments
146: ********************************/
147: l_type_meaning mfg_lookups.meaning%TYPE;
148:
149: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
150:
151: CURSOR all_locs_csr

Line 165: mfg_lookups ml

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
168: AND milk.concatenated_segments LIKE l_loc
169: AND nvl(milk.inventory_location_type, 3) NOT IN (g_loc_type_dock_door)

Line 196: mfg_lookups ml

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
197: WHERE milk.organization_id = p_org_id
198: AND milk.subinventory_code = p_sub
199: AND milk.concatenated_segments LIKE l_loc
200: AND nvl(milk.inventory_location_type, 3) NOT IN (g_loc_type_dock_door)

Line 670: mfg_lookups ml

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
673: AND milk.subinventory_code = p_sub
674: AND milk.project_id IS NULL

Line 704: mfg_lookups ml

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
705: WHERE milk.organization_id = p_org_id
706: AND milk.subinventory_code = p_sub
707: AND milk.alias = p_alias
708: AND nvl(milk.inventory_location_type, 3) NOT IN (g_loc_type_dock_door)

Line 758: mfg_lookups ml

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
761: AND milk.subinventory_code = p_sub
762: AND milk.project_id IS NULL

Line 792: mfg_lookups ml

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
793: WHERE milk.organization_id = p_org_id
794: AND milk.subinventory_code = p_sub
795: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc -- bug 2769126
796: AND nvl(milk.inventory_location_type, 3) NOT IN (g_loc_type_dock_door)

Line 1987: mfg_lookups ml,

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
1991: AND milk.subinventory_code = p_sub

Line 2052: mfg_lookups ml

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
2056: AND milk.inventory_location_id = Nvl(mil.physical_location_id, mil.inventory_location_id)

Line 2121: mfg_lookups ml,

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
2125: AND milk.subinventory_code = p_sub

Line 2186: mfg_lookups ml

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
2190: AND milk.inventory_location_id = Nvl(mil.physical_location_id, mil.inventory_location_id)

Line 2300: mfg_lookups ml

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
2304: AND milk.inventory_location_id = mil.inventory_location_id

Line 2350: mfg_lookups ml

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
2354: AND milk.inventory_location_id = mil.inventory_location_id

Line 2390: mfg_lookups ml

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
2394: AND milk.organization_id = mil.organization_id