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 INV_PROJECT

Line 319: x_loc := INV_PROJECT.GET_LOCSEGS(l_loc_id,p_org_id);

315: RAISE FND_API.g_exc_error;
316:
317: END IF;
318:
319: x_loc := INV_PROJECT.GET_LOCSEGS(l_loc_id,p_org_id);
320: x_return_status := l_return_status;
321:
322: IF (l_debug = 1) THEN
323:

Line 375: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

371: OPEN x_lpn_lov FOR
372: SELECT DISTINCT
373: wlpn.license_plate_number,
374: milk.subinventory_code,
375: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
376: wlpn.lpn_id,
377: /* Need to get LocatorId for LMS project, added by Anupam Jain*/
378: milk.inventory_location_id,
379: /* lms code end */

Line 662: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

658: OPEN x_loc_lov FOR
659:
660: SELECT DISTINCT
661: milk.inventory_location_id,
662: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
663: milk.description,
664: ml.meaning,
665: mil.picking_order
666: FROM

Line 694: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

690: OPEN x_loc_lov FOR
691:
692: SELECT DISTINCT
693: milk.inventory_location_id,
694: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
695: milk.description,
696: ml.meaning,
697: mil.picking_order
698: FROM

Line 750: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

746: OPEN x_loc_lov FOR
747:
748: SELECT DISTINCT
749: milk.inventory_location_id,
750: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
751: milk.description,
752: ml.meaning,
753: mil.picking_order
754: FROM

Line 760: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc -- bug 2769126

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
763: AND milk.task_id IS NULL
764: AND nvl(milk.inventory_location_type, 3) NOT IN (g_loc_type_dock_door)

Line 782: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

778: OPEN x_loc_lov FOR
779:
780: SELECT DISTINCT
781: milk.inventory_location_id,
782: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
783: milk.description,
784: ml.meaning,
785: mil.picking_order
786: FROM

Line 795: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc -- bug 2769126

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)
797: AND mil.inventory_location_id = wlpn.locator_id
798: AND milk.inventory_location_id = Nvl(mil.physical_location_id, mil.inventory_location_id)
799: AND milk.organization_id = mil.organization_id

Line 904: inv_projectlocator_pub.get_project_number(mil.project_id),

900: SELECT DISTINCT
901: wda.delivery_id,
902: wlpno.license_plate_number,
903: wlpn.locator_id,
904: inv_projectlocator_pub.get_project_number(mil.project_id),
905: inv_projectlocator_pub.get_task_number(mil.task_id)
906: INTO
907: x_delivery_id,
908: x_lpn,

Line 905: inv_projectlocator_pub.get_task_number(mil.task_id)

901: wda.delivery_id,
902: wlpno.license_plate_number,
903: wlpn.locator_id,
904: inv_projectlocator_pub.get_project_number(mil.project_id),
905: inv_projectlocator_pub.get_task_number(mil.task_id)
906: INTO
907: x_delivery_id,
908: x_lpn,
909: l_loc_id,

Line 971: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,

967: wda.delivery_id,
968: wlpno.license_plate_number,
969: wlpn.locator_id,
970: wlpn.subinventory_code,
971: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
972: inv_projectlocator_pub.get_project_number(mil.project_id),
973: inv_projectlocator_pub.get_task_number(mil.task_id)
974: INTO
975: x_delivery_id,

Line 972: inv_projectlocator_pub.get_project_number(mil.project_id),

968: wlpno.license_plate_number,
969: wlpn.locator_id,
970: wlpn.subinventory_code,
971: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
972: inv_projectlocator_pub.get_project_number(mil.project_id),
973: inv_projectlocator_pub.get_task_number(mil.task_id)
974: INTO
975: x_delivery_id,
976: x_lpn,

Line 973: inv_projectlocator_pub.get_task_number(mil.task_id)

969: wlpn.locator_id,
970: wlpn.subinventory_code,
971: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
972: inv_projectlocator_pub.get_project_number(mil.project_id),
973: inv_projectlocator_pub.get_task_number(mil.task_id)
974: INTO
975: x_delivery_id,
976: x_lpn,
977: l_loc_id,

Line 1016: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,

1012: SELECT
1013: wlpn.license_plate_number,
1014: wlpn.locator_id,
1015: wlpn.subinventory_code,
1016: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1017: inv_projectlocator_pub.get_project_number(mil.project_id),
1018: inv_projectlocator_pub.get_task_number(mil.task_id)
1019:
1020: INTO

Line 1017: inv_projectlocator_pub.get_project_number(mil.project_id),

1013: wlpn.license_plate_number,
1014: wlpn.locator_id,
1015: wlpn.subinventory_code,
1016: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1017: inv_projectlocator_pub.get_project_number(mil.project_id),
1018: inv_projectlocator_pub.get_task_number(mil.task_id)
1019:
1020: INTO
1021: x_lpn,

Line 1018: inv_projectlocator_pub.get_task_number(mil.task_id)

1014: wlpn.locator_id,
1015: wlpn.subinventory_code,
1016: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1017: inv_projectlocator_pub.get_project_number(mil.project_id),
1018: inv_projectlocator_pub.get_task_number(mil.task_id)
1019:
1020: INTO
1021: x_lpn,
1022: l_loc_id,

Line 1051: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,

1047: SELECT
1048: wlpn.license_plate_number,
1049: wlpn.locator_id,
1050: wlpn.subinventory_code,
1051: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1052: inv_projectlocator_pub.get_project_number(mil.project_id),
1053: inv_projectlocator_pub.get_task_number(mil.task_id)
1054:
1055: INTO

Line 1052: inv_projectlocator_pub.get_project_number(mil.project_id),

1048: wlpn.license_plate_number,
1049: wlpn.locator_id,
1050: wlpn.subinventory_code,
1051: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1052: inv_projectlocator_pub.get_project_number(mil.project_id),
1053: inv_projectlocator_pub.get_task_number(mil.task_id)
1054:
1055: INTO
1056: x_lpn,

Line 1053: inv_projectlocator_pub.get_task_number(mil.task_id)

1049: wlpn.locator_id,
1050: wlpn.subinventory_code,
1051: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1052: inv_projectlocator_pub.get_project_number(mil.project_id),
1053: inv_projectlocator_pub.get_task_number(mil.task_id)
1054:
1055: INTO
1056: x_lpn,
1057: l_loc_id,

Line 1102: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,

1098: wda.delivery_id,
1099: wlpno.license_plate_number,
1100: wlpn.locator_id,
1101: wlpn.subinventory_code,
1102: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1103: inv_projectlocator_pub.get_project_number(mil.project_id),
1104: inv_projectlocator_pub.get_task_number(mil.task_id)
1105:
1106: INTO

Line 1103: inv_projectlocator_pub.get_project_number(mil.project_id),

1099: wlpno.license_plate_number,
1100: wlpn.locator_id,
1101: wlpn.subinventory_code,
1102: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1103: inv_projectlocator_pub.get_project_number(mil.project_id),
1104: inv_projectlocator_pub.get_task_number(mil.task_id)
1105:
1106: INTO
1107: x_delivery_id,

Line 1104: inv_projectlocator_pub.get_task_number(mil.task_id)

1100: wlpn.locator_id,
1101: wlpn.subinventory_code,
1102: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1103: inv_projectlocator_pub.get_project_number(mil.project_id),
1104: inv_projectlocator_pub.get_task_number(mil.task_id)
1105:
1106: INTO
1107: x_delivery_id,
1108: x_lpn,

Line 1980: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

1976: OPEN x_loc_lov FOR
1977:
1978: SELECT DISTINCT
1979: milk.inventory_location_id,
1980: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
1981: milk.description,
1982: ml.meaning,
1983: mil.picking_order
1984: FROM

Line 2045: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

2041: OPEN x_loc_lov FOR
2042:
2043: SELECT DISTINCT
2044: milk.inventory_location_id,
2045: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2046: milk.description,
2047: ml.meaning,
2048: mil.picking_order
2049: FROM

Line 2114: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

2110: OPEN x_loc_lov FOR
2111:
2112: SELECT DISTINCT
2113: milk.inventory_location_id,
2114: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2115: milk.description,
2116: ml.meaning,
2117: mil.picking_order
2118: FROM

Line 2124: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

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
2126: AND milk.project_id IS NULL
2127: AND milk.task_id IS NULL
2128: AND nvl(milk.inventory_location_type, 3) IN (g_loc_type_consolidation,

Line 2179: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

2175: OPEN x_loc_lov FOR
2176:
2177: SELECT DISTINCT
2178: milk.inventory_location_id,
2179: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2180: milk.description,
2181: ml.meaning,
2182: mil.picking_order
2183: FROM

Line 2188: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

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)
2191: AND milk.organization_id = mil.organization_id
2192: AND milk.project_id IS NULL

Line 2244: inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) concatenated_segments,

2240: SELECT DISTINCT
2241: wlpn.lpn_id,
2242: wlpn.license_plate_number,
2243: milk.inventory_location_id,
2244: inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2245: milk.subinventory_code,
2246: 11 lpn_context
2247: FROM
2248: wms_license_plate_numbers wlpn,

Line 2293: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

2289: OPEN x_loc_lov FOR
2290:
2291: SELECT DISTINCT
2292: milk.inventory_location_id,
2293: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2294: milk.description,
2295: ml.meaning,
2296: mil.dropping_order
2297: FROM

Line 2302: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc

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
2305: AND milk.organization_id = mil.organization_id
2306: AND milk.project_id IS NULL

Line 2343: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

2339: OPEN x_loc_lov FOR
2340:
2341: SELECT DISTINCT
2342: milk.inventory_location_id,
2343: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2344: milk.description,
2345: ml.meaning,
2346: mil.dropping_order
2347: FROM

Line 2384: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

2380:
2381: CURSOR empty_loc_csr IS
2382:
2383: SELECT DISTINCT
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,