DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on INV_PROJECTLOCATOR_PUB

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