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 665: mfg_lookups ml

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

Line 699: mfg_lookups ml

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
700: WHERE milk.organization_id = p_org_id
701: AND milk.subinventory_code = p_sub
702: AND milk.alias = p_alias
703: AND nvl(milk.inventory_location_type, 3) NOT IN (g_loc_type_dock_door)

Line 753: mfg_lookups ml

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

Line 787: mfg_lookups ml

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

Line 1982: mfg_lookups ml,

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

Line 2047: mfg_lookups ml

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

Line 2116: mfg_lookups ml,

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

Line 2181: mfg_lookups ml

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

Line 2295: mfg_lookups ml

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

Line 2345: mfg_lookups ml

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

Line 2385: mfg_lookups ml

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