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