APPS.INV_PROJECT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1105: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn

1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102:
1103: SELECT mil.segment19, mil.segment20
1104: INTO l_project_id, l_task_id
1105: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn
1106: WHERE wlpn.lpn_id = p_lpn_id
1107: AND wlpn.organization_id = p_organization_id
1108: AND wlpn.organization_id = mil.organization_id
1109: AND wlpn.locator_id = mil.inventory_location_id;

Line 1605: * FROM WMS_LICENSE_PLATE_NUMBERS

1601: * INV_PROJECT.GET_PROJECT_NUMBER,
1602: * INV_PROJECT.GET_TASK_ID,
1603: * INV_PROJECT.GET_TASK_NUMBER,
1604: * ..
1605: * FROM WMS_LICENSE_PLATE_NUMBERS
1606: *
1607: */
1608: FUNCTION GET_PROJECT_NUMBER RETURN VARCHAR2 IS
1609: BEGIN