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 657: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,

653: OPEN x_loc_lov FOR
654:
655: SELECT DISTINCT
656: milk.inventory_location_id,
657: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
658: milk.description,
659: ml.meaning,
660: mil.picking_order
661: FROM

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

685: OPEN x_loc_lov FOR
686:
687: SELECT DISTINCT
688: milk.inventory_location_id,
689: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
690: milk.description,
691: ml.meaning,
692: mil.picking_order
693: FROM

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

741: OPEN x_loc_lov FOR
742:
743: SELECT DISTINCT
744: milk.inventory_location_id,
745: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
746: milk.description,
747: ml.meaning,
748: mil.picking_order
749: FROM

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

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

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

773: OPEN x_loc_lov FOR
774:
775: SELECT DISTINCT
776: milk.inventory_location_id,
777: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
778: milk.description,
779: ml.meaning,
780: mil.picking_order
781: FROM

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

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)
792: AND mil.inventory_location_id = wlpn.locator_id
793: AND milk.inventory_location_id = Nvl(mil.physical_location_id, mil.inventory_location_id)
794: AND milk.organization_id = mil.organization_id

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

895: SELECT DISTINCT
896: wda.delivery_id,
897: wlpno.license_plate_number,
898: wlpn.locator_id,
899: inv_projectlocator_pub.get_project_number(mil.project_id),
900: inv_projectlocator_pub.get_task_number(mil.task_id)
901: INTO
902: x_delivery_id,
903: x_lpn,

Line 900: inv_projectlocator_pub.get_task_number(mil.task_id)

896: wda.delivery_id,
897: wlpno.license_plate_number,
898: wlpn.locator_id,
899: inv_projectlocator_pub.get_project_number(mil.project_id),
900: inv_projectlocator_pub.get_task_number(mil.task_id)
901: INTO
902: x_delivery_id,
903: x_lpn,
904: l_loc_id,

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

962: wda.delivery_id,
963: wlpno.license_plate_number,
964: wlpn.locator_id,
965: wlpn.subinventory_code,
966: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
967: inv_projectlocator_pub.get_project_number(mil.project_id),
968: inv_projectlocator_pub.get_task_number(mil.task_id)
969: INTO
970: x_delivery_id,

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

963: wlpno.license_plate_number,
964: wlpn.locator_id,
965: wlpn.subinventory_code,
966: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
967: inv_projectlocator_pub.get_project_number(mil.project_id),
968: inv_projectlocator_pub.get_task_number(mil.task_id)
969: INTO
970: x_delivery_id,
971: x_lpn,

Line 968: inv_projectlocator_pub.get_task_number(mil.task_id)

964: wlpn.locator_id,
965: wlpn.subinventory_code,
966: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
967: inv_projectlocator_pub.get_project_number(mil.project_id),
968: inv_projectlocator_pub.get_task_number(mil.task_id)
969: INTO
970: x_delivery_id,
971: x_lpn,
972: l_loc_id,

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

1007: SELECT
1008: wlpn.license_plate_number,
1009: wlpn.locator_id,
1010: wlpn.subinventory_code,
1011: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1012: inv_projectlocator_pub.get_project_number(mil.project_id),
1013: inv_projectlocator_pub.get_task_number(mil.task_id)
1014:
1015: INTO

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

1008: wlpn.license_plate_number,
1009: wlpn.locator_id,
1010: wlpn.subinventory_code,
1011: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1012: inv_projectlocator_pub.get_project_number(mil.project_id),
1013: inv_projectlocator_pub.get_task_number(mil.task_id)
1014:
1015: INTO
1016: x_lpn,

Line 1013: inv_projectlocator_pub.get_task_number(mil.task_id)

1009: wlpn.locator_id,
1010: wlpn.subinventory_code,
1011: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1012: inv_projectlocator_pub.get_project_number(mil.project_id),
1013: inv_projectlocator_pub.get_task_number(mil.task_id)
1014:
1015: INTO
1016: x_lpn,
1017: l_loc_id,

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

1042: SELECT
1043: wlpn.license_plate_number,
1044: wlpn.locator_id,
1045: wlpn.subinventory_code,
1046: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1047: inv_projectlocator_pub.get_project_number(mil.project_id),
1048: inv_projectlocator_pub.get_task_number(mil.task_id)
1049:
1050: INTO

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

1043: wlpn.license_plate_number,
1044: wlpn.locator_id,
1045: wlpn.subinventory_code,
1046: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1047: inv_projectlocator_pub.get_project_number(mil.project_id),
1048: inv_projectlocator_pub.get_task_number(mil.task_id)
1049:
1050: INTO
1051: x_lpn,

Line 1048: inv_projectlocator_pub.get_task_number(mil.task_id)

1044: wlpn.locator_id,
1045: wlpn.subinventory_code,
1046: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1047: inv_projectlocator_pub.get_project_number(mil.project_id),
1048: inv_projectlocator_pub.get_task_number(mil.task_id)
1049:
1050: INTO
1051: x_lpn,
1052: l_loc_id,

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

1093: wda.delivery_id,
1094: wlpno.license_plate_number,
1095: wlpn.locator_id,
1096: wlpn.subinventory_code,
1097: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1098: inv_projectlocator_pub.get_project_number(mil.project_id),
1099: inv_projectlocator_pub.get_task_number(mil.task_id)
1100:
1101: INTO

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

1094: wlpno.license_plate_number,
1095: wlpn.locator_id,
1096: wlpn.subinventory_code,
1097: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1098: inv_projectlocator_pub.get_project_number(mil.project_id),
1099: inv_projectlocator_pub.get_task_number(mil.task_id)
1100:
1101: INTO
1102: x_delivery_id,

Line 1099: inv_projectlocator_pub.get_task_number(mil.task_id)

1095: wlpn.locator_id,
1096: wlpn.subinventory_code,
1097: INV_PROJECT.GET_LOCSEGS(wlpn.locator_id, wlpn.organization_id) concatenated_segments,
1098: inv_projectlocator_pub.get_project_number(mil.project_id),
1099: inv_projectlocator_pub.get_task_number(mil.task_id)
1100:
1101: INTO
1102: x_delivery_id,
1103: x_lpn,

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

1971: OPEN x_loc_lov FOR
1972:
1973: SELECT DISTINCT
1974: milk.inventory_location_id,
1975: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
1976: milk.description,
1977: ml.meaning,
1978: mil.picking_order
1979: FROM

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

2036: OPEN x_loc_lov FOR
2037:
2038: SELECT DISTINCT
2039: milk.inventory_location_id,
2040: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2041: milk.description,
2042: ml.meaning,
2043: mil.picking_order
2044: FROM

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

2105: OPEN x_loc_lov FOR
2106:
2107: SELECT DISTINCT
2108: milk.inventory_location_id,
2109: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2110: milk.description,
2111: ml.meaning,
2112: mil.picking_order
2113: FROM

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

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

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

2170: OPEN x_loc_lov FOR
2171:
2172: SELECT DISTINCT
2173: milk.inventory_location_id,
2174: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2175: milk.description,
2176: ml.meaning,
2177: mil.picking_order
2178: FROM

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

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

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

2235: SELECT DISTINCT
2236: wlpn.lpn_id,
2237: wlpn.license_plate_number,
2238: milk.inventory_location_id,
2239: inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2240: milk.subinventory_code,
2241: 11 lpn_context
2242: FROM
2243: wms_license_plate_numbers wlpn,

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

2284: OPEN x_loc_lov FOR
2285:
2286: SELECT DISTINCT
2287: milk.inventory_location_id,
2288: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2289: milk.description,
2290: ml.meaning,
2291: mil.dropping_order
2292: FROM

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

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

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

2334: OPEN x_loc_lov FOR
2335:
2336: SELECT DISTINCT
2337: milk.inventory_location_id,
2338: INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) concatenated_segments,
2339: milk.description,
2340: ml.meaning,
2341: mil.dropping_order
2342: FROM

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

2375:
2376: CURSOR empty_loc_csr IS
2377:
2378: SELECT DISTINCT
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,