APPS.WMS_CONSOLIDATION_PUB dependencies on INV_PROJECTLOCATOR_PUB

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